MAC Powerbook G4, OS 10.5.6 Excel 2004

I have a worksheet with many rows having 8 columns of data. Each column has
a header name (First cell in column is name for column data). All data is
one contiguous region.

I want to macro to a new worksheet with 1 column of data with the 8 columns
(A:H) of the original data transposed into the new sheet column A. If I have
50 rows of 8 columns to start, I will end up with 1 column with 400 rows.

For example


D04/04/2008 T-410.00 CX N1001 PAchillean M03-29-20 L1099 ^
D04/11/2008 T-490.00 CX N1004 PAchillean M4-5-20 L1099 ^

Becomes


D04/04/2008
T-410.00
CX
N1001
PAchillean
M03-29-20
L1099
^
D04/11/2008
T-490.00
CX
N1004
PAchillean
M4-5-20
L1099
^