need help with transpose

[simasarry123]

I am trying to transpose data in alteryx. I can do so in excel but not in alteryx. Attached is the data with existing and desired date tab

[Gaurav_Dhama_]

This data contains multiple tables, so you will need to break this data into multiple parts and then transpose.

Break the tables at every total row and transpose it separately.

Join it back on Employee and Month to the original data.
i can provide an example once i get back to my laptop.

[Yoshiro_Fujimori · Accepted solution]

The challenge is that the Employee ID is not populated in all columns.

So the 1st thing is to populate them.

Then you can Transpose and Cross Tab.

It seems the result is aligned to your desired output.

[simasarry123]

Thank you . This works. Was a bit complicated for me to understand how to play around with rows and columns.

[Gaurav_Dhama_]

@Yoshiro_Fujimori that is nicely done! Very Neat solution.

[jrlindem]

@Yoshiro_Fujimori nice job.  I played around with this a bit late last night.  In reviewing your approach, I did a very similar method to get the Employee ID casted onto each column, but was getting tripped up, like the author, on the transpose/cross-tab part.  Learned from your solution, so thank you!  -Jay