I have solved every problem. Though it is not about M Language, I used M in some instances to make things neater and shorter.

 

Filtering Rows and adding a Year Column

 

FromFolder

 

Introduction

 

Modulo

 

Parsing URLs in Excel Power Query

 

Split Columns into Other Columns