Excel Is Fun

Excel 2013 Power Query 03

May 22, 2015 0

Merge 3 Tables Into One in PowerPivot or Excel Table DESCRIPTION See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Powery Query 1 […]

Excel Is Fun

Excel 2013 Power Query 02

May 15, 2015 0

Merge 3 Tables Into One in PowerPivot or Excel Table DESCRIPTION See how to: (00:32) Explain Data and how we will transform it (01:35) Import Excel Table (01:58) Remove unwanted columns (02:10) Split Columns to […]

Excel Is Fun

Excel 2013 Power Query 01

May 13, 2015 0

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 […]