How can I combine multiple columns into one?

[navaiva]

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.

[MarqueeCrew · Accepted solution]

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!

[MarqueeCrew]

You're welcome :) 

Glad to help.