Convert rows to columns using Power Query – Excel and Power BI

If you get data in a single column with multiple records, you can easily convert it to multiple columns using Power Query. Watch and Try with the Sample file we have given below. Do let us know what you think in the comments.

Download sample file and follow along

Contents

1. The problem – 00:00
2. Import in Power Query – 00:34
3. Add Index column – 00:58
4. Add row indicator – 01:12
5. Add column indicator – 02:07
6. Pivot data – 02:54
7. Data types and Column Names – 03:25
8. Import data – 04:05
9. Add more data and refresh – 04:26
10. Summary – 04:41

Related videos

Pivot data using Power Query – Key Value to Tabular

Append multiple columns to one column – Power Query

Split column by position – Power Query

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

How to check data quality in Power Query