Power Query append tables and sort columns

[TopLearner]

Good evening,

I hope you are well.

I have a file where I have a tab called Append1 which is the result of appending the three tables for Almeria on another tab

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

 

[KRice]

It is simpler to rename the column headings for each of your tables in Power Query so that they will automatically align themselves. For each of the three source queries (formed by loading each of the three tables into PQ), double click on the column heading of any column that does not have the preferred wording and edit the text (i.e., change "All" to "Total" and change "SCORING" and "Column1" to "CURRENT SEQUENCES"). Then execute the append query (Table.Combine) and the columns will match themselves.