View Single Post
  #1   Report Post  
Kev Nurse
 
Posts: n/a
Default 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