S
swtanjewel
How do I merge multiple columns without loossing each columns data?
G
Gord Dibben
In an empty column enter a formula.
=A1 & B1 & C1 & D1 entered in E1
Drag/copy down column E
If you want spaces between use
=A1 & " " & B1 & " " & etc.
When happy, select column E and Copy then Edit>Paste Special(in
place)>Values>OK>Esc
Delete A through D
Gord Dibben MS Excel MVP
=A1 & B1 & C1 & D1 entered in E1
Drag/copy down column E
If you want spaces between use
=A1 & " " & B1 & " " & etc.
When happy, select column E and Copy then Edit>Paste Special(in
place)>Values>OK>Esc
Delete A through D
Gord Dibben MS Excel MVP
S
swtanjewel
Thank you 
Gord Dibben said: