Transform data

D_Y

Hi community

I have a dataset that looks like this:

For dashboarding purposes, I am trying to get it to become like this:

I have tried using the Transpose tool but am having trouble performing the exact steps needed to get there.

I attached the sample file of the two screenshots.

Thanks in advance for any help!

Sample Format.xlsx

Transformation

Accepted answers

chuckleswk

The attached flow should get you the output that you're looking for. You have to do several different transposes to get your desired output.

Transform Data.yxmd

All comments

chuckleswk

The attached flow should get you the output that you're looking for. You have to do several different transposes to get your desired output.

Transform Data.yxmd

D_Y

Thanks for your help! This is exactly what I needed! And wow, definitely a couple more steps/tools than I thought.

chuckleswk

Glad I was able to help you out! That was the easiest way for me to build it out. It may be possible to do it in fewer steps....but this was the fastest way to get you the results you were looking for.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703