Python vs Power Query or VSTACK for Combining Tables

Combining data from multiple tables is a common task in Excel, and it can be done in so many ways.
I am Nabil Mourad
In this tutorial I show you how to combine data from multiple Tables using Python, Power Query or using Dynamic array functions.
Write me in a comment which method you prefer.
And now let’s have a look at the source tables.
You can read the related Blog article and download the exercise File by clicking on the link:

[sasavienne]

Thank you so much. I like using VSTACK. It is a fast way to combine tables.

[IvanCortinas_ES]

I prefer VSTACK. I'm currently having issues with my 365 account and can't use Python.
I think Python is going to help a lot in data analysis, with graphs.
Power Query is here to stay.
Thank you my great friend.

[BackPly]

Thanks for this, i think power query is best due to backwards compatibility with older versions of excel.

[micheltremblay]

Thank you very much, I preferred VSTACK but Python is not far away

[mcwahaab]

The steps in Power Query seem to be detailed compared to Python and VSTACK, However, because of its ability to refresh and auto-link to Power BI, I see PQ as the best of the 3 options.

[richardhay]

I am confroted with this situation frequently. I always use VSTACK. Quick, easy and automstic update
What not to like? 2nd place goes to Python which leaves PQ which I use only for gatting data from other siurces into Excel

[ubaidillahmuhammad]

Nice. I have bought one of your product. Please put the excel file in the description

[SamehRSameh]

Really you are excellent 🎉
I think we need to know 3 ways
Please always make tutorials about excel python & query and dax

[nadermounir]

I prefer Vstack as it is the easiest one and it updates automatically