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

Microsoft Excel: Learn Power Query Basics! - image 1 - student project

FromFolder

Microsoft Excel: Learn Power Query Basics! - image 2 - student project

Introduction

Microsoft Excel: Learn Power Query Basics! - image 3 - student project

Modulo Microsoft Excel: Learn Power Query Basics! - image 4 - student project

Parsing URLs in Excel Power Query

Microsoft Excel: Learn Power Query Basics! - image 5 - student project

Split Columns into Other Columns

Microsoft Excel: Learn Power Query Basics! - image 6 - student project

Aditya Kumar Darak

3