About this tutorial:
Video duration: 5:4
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…