Convert table to a single column

M

Majeed B

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
 
×

מיכ×ל (מיקי) ×בידן

As you did not mentioned anything about "closing the gaps":
a) Name the Range A1:G5 [5 rows, 7 columns] as: DATA
b) in Cell H1 type and copy down until H35
=INDEX(DATA,IF(MOD(ROW(),ROWS(DATA))=0,ROWS(DATA),MOD(ROW(),ROWS(DATA))),INT((ROW()-1)/ROWS(DATA))+1)
Micky
 

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

Setting column width in a table with a macro is not working 0
Sorting Multiple Tables 1
Cannot sort a table containing text 5
Format column widths from one table to a separate table on same page 1
Insert Index into a Table 1
How to bulk add section breaks after a particular combination of letters/numbers 0
Two columns followed by single page-width column on same page 0
Consolidation Table from Different Excel Tabs with Different Format 1

Top