Data Clean Up: Column groups into tabular columns

Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format)  using Power Query. Watch the video. Sample File download.

[youtube https://www.youtube.com/watch?v=fWsAFNHO1OY?rel=0]

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,750 other subscribers

Popular articles

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

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

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.