Combine data in two columns into one and sort the combined column alphabetically..how??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tommy - 09 Aug 2007 11:11 GMT

I have two columns, A and B. Each column contains a list of data in
text format e.g. 01TI518A.PV . It is possible that duplicates of this
text may appear within either column. Also, the number of data values
in each column is variable as they are imported from an external
source into the worksheet. I would like to be able to combine the text
from both columns into a single list in a single column, say column C.
I would also like this column to be alphanumerically sorted. How do I
go about doing this?

Reply to this Message

Dave Peterson - 09 Aug 2007 12:33 GMT

I would do this.

Copy the data from column A to column C (include a single header row)
copy the data from column B to the bottom of the data in column C. Do not
include the header.

Use data|filter|advanced filter to get a list of unique customers. Put this
unique list in column D. Look at Debra Dalgleish's site for Advanced filter
with unique records.
http://contextures.com/xladvfilter01.html#FilterUR

Delete column C (since column D has that unique list).

If you really want it to be automatic, try recording a macro when you do it
manually.

> I have two columns, A and B. Each column contains a list of data in
> text format e.g. 01TI518A.PV . It is possible that duplicates of this
[quoted text clipped - 4 lines]
> I would also like this column to be alphanumerically sorted. How do I
> go about doing this?

Signature

Dave Peterson

Reply to this Message

Rate this thread: