Transpose Data Table

Question

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 :)

Payroll Log Format.xlsx

gautiergodard · Accepted Answer

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 Answer

THANK YOU!!! That worked perfectly.