View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Majeed B Majeed B is offline
external usenet poster
 
Posts: 3
Default Convert table to a single column

Hi,
For Excel 2007
Two question:
I have a table with5 rows and 7 column with few blanks in the table. I want
to convert the table into a single column. I have 59 cell like this and I
want to convert all of them.

Second, After wards I need to sort them from low to high in each column. I
know sorting is easy by sort function but when I select multiple column to
sort it only sort the first one.

Thanks