View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default Merging multiple columns of data into one column of data

Copy your columns
Paste - Special - Transpose

"Archangel" wrote:

I have a large spread sheet that I inherited... I need to merge five columns
of text data into one column.
Example:

Before...
A B C D E
The Quick Brown Fox Jumped

After...
A
The
Quick
Brown
Fox
Jumped

Help!