Hi all, I am new to alteryx. I have a data source which has multiple columns, and I would like it to create a new row for each column. How would I be able to do this?
Hi, thanks you for all of your responses. What if I want to move only a certain number of columns?
Type Client Earnings Type2 Type3 Type4 Type5
1 1242302.55 0.00 -14455.38 24585.44 -351306.29
2 -153653.65 0.00
3 13877297.6 74218.97
4 5752.74 0.00
Type Client Earnings
1 1242302.55
2 -153653.65
3 13877297.6
4 5752.74
Type2 74218.97
Type3 -14455.38
Type4 24585.44
Type5 -351306.29
Solved! Go to Solution.
Hi @Emanuelis sounds like you need to use the Transpose tool. Do you have have any dummy data to build an example from? I have mocked up my own example.
Thanks for your reply. I have edited the question slightly, how could I adapt your solution?
Hi @Emanuelis I mocked up a workflow that produces the output in your reply. Let me know what you think?
Hi @Emanuelis if you found the post helpful could you please mark it as solved?