Excel Magic Trick 1330

Append All Excel Tables in Current Workbook: Power Query (Get & Transform)

DESCRIPTION

See how to use the Power Query Function Excel.CurrentWorkbook function to get all Tables in an Excel Workbook into a Single Table (How To Append All Tables in Current Workbook):
(00:20) Introduction to Excel.CurrentWorkbook function to get all Tables in an Excel Workbook into a Single Column.
(02:52) File has ONLY Excel Tables: Excel.CurrentWorkbook Append with Connection ONLY
(12:09) File has ONLY Excel Tables: Excel.CurrentWorkbook Append and Create New Table (Recursion Trouble)
(18:27) File has Excel Tables, Defined Names & Print Ranges. Excel.CurrentWorkbook Function and Extra Column with Text.Combine & Table.ColumnNames functions.

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply