Sort multiple columns into one column

  • Thread starter Thread starter BeeNeeB
  • Start date Start date
B

BeeNeeB

Once again I am here with yet another problem...

I have several columns of serial numbers that I need to sort into one
column. Is there anyway to just select all of the serial and sort them
automatically? Here is an example of what the spreadsheet looks like:

COLUMN 1 COLUMN 2 COLUMN 3
WBLM015780 WBLM006249 WBLM006249
WBMM025115 WFMM041685 WBLM006249
WDMM020958 WFMM074766 WBLM006249
WDMM021095 WFMM074766 WBLM006249

And I need to put them all into one column. I have hundred of serial
numbers in each column and it would be a pain just to cut and paste.

Thanks in advance!
 
Bee

First. How do you want them sorted? By Text or by number?

Makes quite a difference in steps taken.

If you have only 3 columns you would have to cut and paste only twice to get
them all into one column. Then do your sort on that one column.

If sort by number, you could split into two columns using Data>Text to Columns
then select both columns and sort on the number column.

More detail needed for a good response.

Gord Dibben Excel MVP
 
I don't actually need to "sort" them alphabettically or numerical. I
just have 7 columns or more worth of serial numbers that need to be
copied into 1 column. The only way that I know how to do this is to
copy one column of data and paste it another column. I have attached
an example spreadsheet of what I have to do. The "Before" sheet is the
serial numbers that are in separate columns. The "After" sheet is what
I need the final to look like. I basically have to consolidate data
from several columns and merge them into one column. Is there any EASY
way to do this besides just copying and pasting?

Thanks!

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=446907
 
Bee

See this google search thread for various methods.

http://snipurl.com/3ix1

For that particular problem my macro took 1.6 seconds.

I just tried it on your sample data. Took .9 seconds.

Gord Dibben Excel MVP
 
Back
Top