★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
[ Ссылка ]
File Reference for this video: 0223 Combine Tables - PQ v VSTACK.zip
★ About this video ★
In this video, we look at 2 options for dynamically combining Tables in an Excel workbook.
These options are not interchangeable, so it's important to know how to use them and when to use them.
INCLUDES:
0:00 Introduction
0:16 Scenario
0:39 Power Query
3:19 VSTACK Function
6:16 When to use each?
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]
★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]
#MsExcel
