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! 

[chukleswk · Accepted solution]

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.

 

[D_Y]

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

[chukleswk]

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.