Combining small tables in worksheets that have the same column structure and names is a simple task. But if you had to combine or append the tables from a workbook that had a LOT of worksheets (or tabs), that would be a mind numbing exercise. Also how would you know what worksheet name it came from? With the small worksheet example you could create a helper column and manually enter the worksheet name for those respective table.

If there's 10 or more worksheets (30? 40?), that'll be painful and you might think about learning VBA to do this. Fear not because with a few clicks in Power Query, it can be done in less than 3 minutes.

0:00 Intro
0:17 Manual Example
1:40 Power Query Example

🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]

🏫 Excel Training ➜ [ Ссылка ]

📚 Excel Books & Tech Gear ➜ [ Ссылка ]

⚙️ Tools: Screencasting ➜ [ Ссылка ]

⚙️ Tools: Microsoft Office ➜ [ Ссылка ]

⚙️ Tools: TubeBuddy ➜ [ Ссылка ]

📝 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"
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть