Combine and Unpivot Tables Multiple Worksheets Same File

You have multiple worksheets or tab to combine? It's easy if its just 1 or 2. It's even not that bad if you have to do some kind of transformation like to unpivot the table. However if you have to do a LOT of tables or do it on a recurring basis, then it's becomes a hassle. Power Query can rescue you from the mundane and laborious process of manually doing these steps.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-