Merge 3 Tables Into One in PowerPivot or Excel Table
See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Powery Query 1 Step Method, and then make an amazing Pivot Chart with Dynamic Labels:
(00:08) Problem Setup
(02:45) Import multiple Text Files (Tab Delimited) from a single Folder
(06:43) Build 3 PivotTables for 3 Class Grade
(09:22) Chart with Custom Labels
(09:58) Create Labels for chart that are connected to the PivotTable and Cells. Text formulas with TEXT and CHAR functions.