SHARE

Merge 3 Tables Into One in PowerPivot or Excel Table

See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or an Excel Table

  • 1. Import Access File. Remove column, Format Data Type as Date
  • 2. Import Excel File
  • 3. Import Text File
  • 4. Append Table: merge Three Tables
  • 5. Load to Data Model or Excel Table

Download Video from here

powerquery-video-button

Download Sample DataSet for Practice from here

owerquery-sample-dataset-button

 

themiscellaneousblog
READ  PowerQuery: 2# Transform Data and Import Into PowerPivot or Excel Table