Excel Magic Trick 1436

Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot

DESCRIPTION

See how to use Excel 2016 to take a 900,000 row table and a 1,000,000 roe table and combine them into one in order to make a PivotTable Report. See how to use the Power Query (Get and Transform) Append feature to combine the two tables and the load it to the Data Model in order to create a PivotTable report.

WORKBOOKS

Download “Excel Magic Trick 1436-1440” Excel-Magic-Trick-1436-1440.zip – Downloaded 524 times – 81 MB







Be the first to comment

Leave a Reply