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!
Download the Excel file here:
http://datascopic.net/stack3columns
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2