sort blockwise (excel 2000 or later)

[blackno666]

Hello,

I use excel 2000 and have the following table


Col1 | Col 2
----------------------
Item 2 | Item 2b
| Item 2a
| Item 2c
| Item 2d
Item1 | Item1a
| Item 1b
| Item 1c
....
Item n Item n1

I want to sort that list in a way that I obtain either of the
following:

Item1 | Item1a
| Item 1b
| Item 1c
Item 2 | Item 2b
| Item 2a
| Item 2c
| Item 2d

or

Item1 | Item1a
| Item 1b
| Item 1c
Item 2 | Item 2a
| Item 2b
| Item 2c
| Item 2d

Any ideas how to solve this without programming a macro?

Thanks!

 

[Dave Peterson]

Fill the empty cells in column 1 with the value in the cell above. So that
there are no gaps in your data.

You can use the techniques at Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
http://www.contextures.com/xlVideos01.html#FillBlanks

Then you can sort the way you want.

You can use format|conditional formatting to hide the duplicated values in
column 1 (if it's important).

http://contextures.com/xlCondFormat03.html#Duplicate
(also from Debra's site)