Power Query merge tables with unique header

[viewotst]

Good morning,

I hope you are well.

I have two tabs. On the first one I have 3 tables with data for Almeria and 3 tables with data for Athletic, so 6 in total.
On the other tab, games, I want to retrieve information from the first tab in order to compare both teams stats. The problem that I found is that I would need to merge the three tables for Almeria together and then the three tables for Athletic in order to have just one table per team with an unique header so I can use vlookup.


How could I do so?

Thanks

[viewotst]

I think the attachment option is not functioning?

[AliGW]

If you have the Insider version of 365, you could use VSTACK.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[AliGW]

The attachment function is working fine.

[viewotst]

Working now

[viewotst]

Yes, thanks.

However my question is

Good morning,

I hope you are well.

I have two tabs. On the first one I have 3 tables with data for Almeria and 3 tables with data for Athletic, so 6 in total.
On the other tab, games, I want to retrieve information from the first tab in order to compare both teams stats. The problem that I found is that I would need to merge the three tables for Almeria together and then the three tables for Athletic in order to have just one table per team with an unique header so I can use vlookup.


How could I do so?

[AliGW]

Administrative Note:

It has been only an hour and a half since you last posted. Please do not bump threads until 24 hours have passed, and then only once each day. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping or working and not have the time to look into your issues this minute. Patience is important here. If you have an urgent issue, you may wish to look at paying for help in the Commercial Services sub-forum or hiring a professional consultant in your area. Again, please do not bump threads more often than once in every 24 hours: if you get the help you need today, then great, but you really should not count on it. Thanks for your understanding and patience.