Data shaping cleaning

Thanks for the replies from Ashish_Mathur and KNP.

Hi redomer44 ,

Please follow these steps in Power Query Editor:

1.Duplicate table.

2.Delete the unwanted rows for both tables.

3.Create two new tables:

4.Moving on to similar operations for Table and Table(2), we'll use Table as an example.

5.Expand and fill the field:

6.Filter out the required data.

7.Rename columns.

8.Append two tables:

Result:

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.