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.
Solved! Go to 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
This does exactly what I wanted, Thanks!
You're welcome :)
Glad to help.