Power Query append tables and sort columns

Good evening,

I hope you are well.

I am attaching this file where I have a tab called ?Append1? which is the result of appending the three tables for Almeria on tab ?Goles?.

Can you please help me so the cells in column ?Scoring? and ?Column1? move under ?Current sequences? and the numbers in column ?all? move to column total, please?

Then, how if I want to use it for the other team "Athletic" I guess I just have to duplicate the new append table?




Many thanks

Sanchez