How do I combine tabulated data into a single column and list alphabetically?

  • Thread starter Thread starter Kev Nurse
  • Start date Start date
K

Kev Nurse

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
 
To eliminate the empty cells.

select the column (one at a time)
edit|goto|special|blanks
rightclick on one of the select blanks
choose delete
shift cells up.
(repeat for each column)

===
Start a new worksheet
Copy each column after the last used cell in column A.
Sort your data (no need to remove the blanks, the sort will put them at the
bottom.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I combine these columns into one? 2
How do I separate first and last names into two columns? 2
Sorting multiple columns as 1 list alphabetically? 4
How to insert row and column labels into a single cell 3
How do I drag a,b,c,d down a column into a series? 2
transfer data from 3x15 grid to a single list? 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
How do I sort a database without also sorting the column heading? 1

Back
Top