Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.

Posted on by Bb

Download Excel Files: https://excelisfun.net/files/EMT1714.xlsx
https://excelisfun.net/files/EMT1714Answer.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrent.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrentAnswer.xlsx
https://excelisfun.net/files/EMT1714GradeTables.zip

3 methods to append / Combine Tables in Excel Power Query: 1) Power Query Append Feature, 2) Excel.CurrentWorkbook function to combine all Excel Tables in current workbook, 3) Append csv files from a folder using From Folder feature.
Topics:
1. (00:00) Introduction.
2. (00:52) Excel Tables to use Power Query.
3. (01:10) Method1: Power Query Append Feature
4. (03:56) Method2: Excel.CurrentWorkbook function to combine all Excel Tables in current workbook
5. (08:43) Method 3: Append csv files from a folder using From Folder feature.
6. (12:12) Summary, Closing and Video Links

ExcelIsFunTue, August 10, 2021 4:09am