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.  🙂