grouping items

[ahhhmed]

Hello every one:


I have a list of items in column A

But A2, A4, A5, A9 are empty

All the cells from A1 to A12 are full except the cells I mentioned above.

How can I make excel 2007 group the items without blanks among them noticing that these blanks may change every time, I mean that next time cells A3, A6, and A7 may be blank.

I want to automatically group the items in the column whenever there are blanks.

 

[vasim]

http://www.cpearson.com/excel/noblanks.aspx

 

[ahhhmed]

Thank you for your help, sir