Excel 2013 Power Query 01

Merge 3 Tables Into One in PowerPivot or Excel Table

DESCRIPTION

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
(01:38) Import Access File. Remove column, Format Data Type as Date
(02:33) Import Excel File
(03:05) Import Text File
(03:28) Append Table: merge Three Tables
(04:12) Load to Data Model or Excel Table

WORKBOOKS