Quick Excel Trick to Unstack Data from one Column to Multiple Columns

Quick Excel Trick to Unstack Data from one Column to Multiple Columns

 

 

This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. 

 

If you Google this, you'll find different ways of doing this such as: 

1. Using Excel array functions or the INDEX function 
2. Power Query to unstack data 
3.  Excel macros for unstacking data 
4. Excel add-ins that can unstack.  In this Excel tutorial, we'll take a look at the easiest method of unstacking data. 

The good thing with this method is that it's dynamic so if your source data change, the stacked version also updates automatically. 

 

Related Topics:

• How to Calculate Hours Worked with Excel Power Query (and Properly Sum time) 
• Consolidate and Clean Multiple Excel Sheets in One Pivot Table 
• Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query) 
• Excel Dynamic Filled Map Chart with Power Query