Rows to columns

[Emanuelis]

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

[JosephSerpis]

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.

[RishiK]

Hi 

Have a look at the attached workflow as an example

[Emanuelis]

Thanks for your reply. I have edited the question slightly, how could I adapt your solution?

[JosephSerpis · Accepted solution]

Hi @Emanuelis I mocked up a workflow that produces the output in your reply. Let me know what you think?

[Emanuelis]

You are brilliant, thank you very much

[JosephSerpis]

Hi @Emanuelis if you found the post helpful could you please mark it as solved?