Site logo white shadow

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


  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

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

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,755 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.