Append multiple columns to one column – Power Query

Clean-up data quickly using the amazing Power Query Convert multiple column data into two columns using Excel or Power BI with the UNPIVOT feature of Power Query.

Download sample file

Contents

1. Intro – 00:00
2. Power Query – 00:35
3. Unpivot magic – 01:03
4. Rename columns – 01:54
5. Sort and Remove Duplicates – 02:01
6. Import data – 02:15
7. Refresh on input data change – 02:29
8. Auto refresh on file open – 02:53
9. Real Time Refresh – 03:43

Related videos

Split column by position – Power Query

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

How To Check Data Quality Using Power Query?

How to check data quality in Power Query

Merged rows – Data Clean up – Excel Power Query @efficiency365