software

Column A has cells containing:

0 2003-2004
0CLOTHESTIME STORE INC
C/O GENERAL ACCTG
5325 E HUNTER AVE 03/15/2006
ANAHEIM CA 92807
215.99
217.99
0 200301234 2003-2004 004-018 000027991-8
0 2001-2002
0CROCKER, JAMES R amp; BARBARA J
41398 SHADOW MOUNTAIN WY
HEMET CA 92544 03/15/2006
51.45
51.95
0 200301244 2003-2004 006-165 000028278-1

A cell starting with a zero, four spaces and a range of years (i.e,
2003-2004 or 2001-2003) is the first cell in a 'block'. For example:

This first cell of the first 'block' contains: 0 2003-2004
The first cell of the second 'block' contains: 0 2001-2002

Each 'block' contains either 7 or 8 cells.

I need to transpose each 'block'. But how do I handle the varying
number of cells in each 'block'?