Convert Columns to Rows in Excel (NO Transpose, NO Formulas – SIMPLY UNPIVOT in Power Query)

About this tutorial:

Video duration: 00:05:00
Check Out the Complete Excel Power Query course:
*** Note: On XelPlus you will get additional bonuses that are NOT available on other platforms! Check the course landing page for more info.

It sounds simple to just switch columns to rows – basically transpose horizontal data to vertical. BUT you can’t always use a simple transpose (neither the transpose feature nor the Transpose function) if you only need to transpose parts of your data set. Some columns, instead of all columns.

For example if you have a report in Excel with a list of…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads