SHARE

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

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