How to Stack Columns of Data in Excel: Formula Method, Power Query Method

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!


My book: Guerrilla Data Analysis 2nd Edition
My old blog: