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?
Solved! Go to Solution.
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.
Thank you @AkimasaKajitani this was very helpful!
If the solution author's response helps please don't forget to mark it as a solution.
Cheers and have a nice day!
Hi @Atcodedog05 will remember about this 🙂 Thanks!