Pivot data using Power Query

Pivot data using Power Query and Convert flat data with key – value pairs to tabular data. Simplify analysis. Use Power Query – Pivot Column for conversion.

Download Sample File

For corporate data analytics optimization session send a mail to asknitin@maxoffice.co

Contents

1. The need – 00:00
2. Create Table – 00:22
3. Add Index Column – 00:54
4. Assign row numbers – 01:15
5. Remove Index Column – 02:10
6. Pivot the data – 02:16
7. Check Data Types – 03:01
8. Import data – 03:16
9. Change input data – 03:36

Related videos

Append multiple columns to one column – Power Query

Split column by position – Power Query

Consolidate multiple sheets – similar or unclean data – Power Query Sections