Problem with transposing rows to columns

[Michal_Rakowski]

Hi guys,

I am trying to change this:

Into this:

Unfortunately, transposing the input provides me with 2 columns with Name and Value, and all the rows are being saved one by one below each other. Do you have any idea what can I do?

[AkimasaKajitani · Accepted solution]

Hi @Michal_Rakowski 

Basically Alteryx can't have multi rows header. In this case, we consider "Year" and "Month" rows as Header. So the way is a little difficult.

Step 1. I used the Record ID tool to fix the field position.

Step 2. I used the Transpose tool and Crosstab tool into desired output.

Step 3. I used the Text input tool and join to the data stream to sort into the final output.

Please check the attached workflow.

[Michal_Rakowski]

Thank you @AkimasaKajitani this was very helpful!

[atcodedog05]

Hi @Michal_Rakowski 

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!

[Michal_Rakowski]

Hi @Atcodedog05 will remember about this 🙂 Thanks!