Merging multiple columns of data into one column of data
May not be acceptable with your volume but put this in column and copy down
(assumes data starts in A1):
=OFFSET($A$1,INT((ROW()-1)/5),MOD(ROW()-1,5))
Then copy, paste special= values
HTH
"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!
|