Unstack data across columns with #Excel Pivot Table

Excel Tip - Unstack data

Another commonly seen problem in daily work.  Many hours are spent on reshaping data, we all know that.  Nevertheless, if you are good in Excel, doing this task is not difficult at all.   Indeed, there are many ways to solve this problem.

In the following video, I am going to demonstrate how to solve this problem using a Pivot Table as helper steps.   This approach is quick and dirty, which can be accomplished in a minute or two.  However, as I said, it’s quick and dirty so you will expect limitation for this approach – it’s for one-off only.  Whenever your data changes, you have to do it again.

Let’s watch it in action:

Note: This video has no voice over

With modern Excel, this problem can be solved with Power Query or Dynamic Arrays in a more efficient way.  I will prepare videos to demonstrate it later. Stay tuned. 🙂

Side story:

My brother sent me an Excel video on YouTube.  That is a 5-minute video with no voice over… not even background music.  BUT IT HAS 6M+ views.

As a result, I am making this video with no voice over… with a hope that I can have millions of views too. 😛

Frankly speaking, I will be super happy if I have over 1k views for this video.  🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.