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

/in /by

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!

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2