Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data

See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Powery Query

Step Method, and then make an amazing Pivot Chart with Dynamic Labels:

  • 1. Problem Setup
  • 2. Import multiple Text Files (Tab Delimited) from a single Folder
  • 3. Build 3 PivotTables for 3 Class Grade
  • 4. Chart with Custom Labels
  • 5. Create Labels for chart that are connected to the PivotTable and Cells. Text formulas with TEXT and CHAR functions.


Download Video from here


Download Sample DataSet for Practice from here


READ  PowerQuery Full Video Tutorials with Sample Dataset to Practice