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

the cells in column ?Scoring? and ?Column1? move under ?Current sequences? and the numbers in column ?all? move to column total

is that what you want?

Home	Away	Total	Current Sequences
2	-	-	1 goal scored or more
2	2	4	1 goal conceded or more
-	1	1	No goal scored
-	-	-	No goal conceded
1	-	-	2 goals scored or more
1.50	0.50	1.00	GF per match
1.50	1.00	1.25	GA per match
3.00	1.50	2.25	GF + GA per match
100%	100%	100%	GF+GA over 0.5
100%	50%	75%	GF+GA over 1.5
100%	0%	50%	GF+GA over 2.5
0%	0%	0%	GF+GA over 3.5
0%	0%	0%	GF+GA over 4.5
0%	0%	0%	GF+GA over 5.5
100%	50%	75%	GF+GA over 0.5 at HT
50%	50%	50%	GF+GA over 1.5 at HT
0%	0%	0%	GF+GA over 2.5 at HT
100%	50%	75%	Scoring Rate
100%	50%	75%	Scoring Rate 1st-Half
50%	0%	25%	Scoring Rate 2nd-Half
50%	0%	25%	Scored in both halves
100%	50%	75%	Both teams scored
100%	100%	100%	Conceding Rate
50%	50%	50%	Conceding Rate 1st-Half
50%	50%	50%	Conceding Rate 2nd-Half
0%	0%	0%	Conceded in both halves

Hi Sandy,

Yes, this is what Id like to be able to have. Just being fussy here, current sequence column being the one on the leftmost hand side.

Can you please explain how you have done it?

Thanks
Sanchez

Append tables is very easy than more complicated changing source url because you haven't url in Append query but in basic tables

see example

Sorry I have just edited my previous post.

you don't need load basic tables into the sheet, imho enough to load result tables

the structure of the "original" source tables are always the same and data will be loaded there properly. after that you can change headers, structure, layout or whatever

I suggest to read more here
https://docs.microsoft.com/en-us/power-query/


see example again

Hi Sandy,

Thanks again for your time.


Only issue is that I will be updating the data every week so does it mean I?d have to append the tables each time I am refreshing the data?


Thanks
Sanchez

If they don't change anything in structure it should work well

anyway if something will be wrong you can always back to the forum and ask what's happen

Thank you Sandy,

I have tried it this way and I am getting several errors. I am listing the steps taken and the file attached:

1.I have the three tables for Almeria team and replaced the first column header of each one with the word ?option?

2.I have appended them ?append queries as new?

3.I got my ?Append1? table

4.I have loaded the new table onto a new sheet and checked the box ?add to the data model?

5.After doing the 4th step I got an error ?This won?t work because it would move cells in a table on your worksheet?. I do not understand this. When I clicked ok, the same error came up, then clicked ok and another one came up, and a last one came up when showing the ?Append1? table on the new sheet created.

6.I get an error on my first query which says "Download failed".

Thank you, Sandy,

Then, when the data changes on the website and I refresh the data on my queries, will they get updated as they have different headers name than the ones on the website? If so, will the appended table will automatically change?
If not, will I have to manually change the headers so they queries have the same as the ones on the website? Current sequences, scoring and the third query header in blank?

Attachment 795516

Attachment 795517

Attachment 795518

Attachment 795519

Attachment 795520

firstly: Invalid Attachment specified. If you followed a valid link, please notify the administrator

data from the website is loaded into Source step from the link there
all next steps with changes then append will show data from the web with your headers
btw. did your read something about Power Query from the link in post#8 ? seems you didn't