Transpose Data Table

[CrystalC0203]

Hi There

New user here! I need some help with a transposing my data. I have it currently going down the columns but i'd like the data to show on the rows.

This is my starting point:

This is my desired output:

Thanks in advance for your help :)

[gautiergodard · Accepted solution]

Hey @CrystalC0203 

Here is an approach to give you this report!

I wasnt sure how the CE line was being populated but you should be able to expand on this approach to solve.

Hope this helps!

[CrystalC0203 · Accepted solution]

THANK YOU!!! That worked perfectly.

[DavidSkaife]

Hi @CrystalC0203 

Here is one way of doing it. Unsure where you were getting CE from so left that line out: