Excel challenge: How to transpose data in Excel from horizontal to vertical
I present here a solution beyond using the Transpose Excel function based on Power Query.
Unpivot Columns
Select the Columns you want to keep vertically.
Select "Unpivot Other Columns"
1000 rows limit
There is a weird default limitation.
You can switch on the bottom left "Columns profiling based on entire data set" instead of default "on top 1000 rows"
No comments:
Post a Comment