Rows to columns

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

Best Practices

Accepted answers

JosephSerpis

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

Transpose_Example.yxmd

All comments

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.

Transpose.yxmd

rkapoor

Have a look at the attached workflow as an example

workflow_emmanuelis.yxmd

Emanuelis

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

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335