| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I combine tabulated data into a single column and list alphabetically?
Hi,
I have tabulated (grid) text strings (names) in cells in various columns and rows with the occasional unavoidable blank cell in the grid. How do create a single column of data (text strings) listed alphabetically? The icing on the cake would be to eliminate any gaps created by the original grid such that the column is unbroken. Any guidance would be much appreciated. Thanks Kev Nurse |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Threaded Mode
