Lately, there have been a number of requests for stacking data that's in multiple columns.

This video shows 2 methods for stacking 3 columns of data:
- The INDIRECT formula can be used once we know the pattern of how the data needs to be rearranged.
- In Get & Transform (Power Query) it's simple: add an index column, then "unpivot other columns." BOOM! DONE!

Download the Excel file here:
[ Ссылка ]


Website: [ Ссылка ]

My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]

My old blog: [ Ссылка ]

свернуть