Can someone help me to combine multiple columns of data into one? Column 1 Column 2 Column 3 A D F B E C Desired output A B C D E F If I use formulas and concatenate I end up with all of the data in one single row (ABCDEF) and I do not want that.

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

How can I combine multiple columns into one?

Can someone help me to combine multiple columns of data into one?

Column 1	Column 2	Column 3
A	D	F
B	E
C

Desired output

If I use formulas and concatenate I end up with all of the data in one single row (ABCDEF) and I do not want that.

Preparation

Accepted answers

MarqueeCrew

TRANSPOSE tool:

Select the columns as DATA.

Your ouput will look like NAME in one field and VALUE in the 2nd field. Put a select after the TRANSPOSE and uncheck the NAME field. You can name the "VALUE" as appropriate.

Thanks,

Mark

All comments

MarqueeCrew

TRANSPOSE tool:

Select the columns as DATA.

Your ouput will look like NAME in one field and VALUE in the 2nd field. Put a select after the TRANSPOSE and uncheck the NAME field. You can name the "VALUE" as appropriate.

Thanks,

Mark

navaiva

This does exactly what I wanted, Thanks!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335