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

[Tommy]

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?

 

[Dave Peterson]

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.