| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine data in two columns into one and sort the combined column alphabetically..how??
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
| Combine the data in 2 columns of 20 rows into one column of 40 row | Excel Discussion (Misc queries) | |||
| How to combine data from two columns into one column? | Excel Worksheet Functions | |||
| How do I sort a column alphabetically not consider "the" or "a"? | Excel Discussion (Misc queries) | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
![Tommy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
