A macro is not needed. If your data is in column A, then in B1 enter:
=INDIRECT("A" & ROW()*4-3) and copy down

and in C1 enter:
=INDIRECT("A" & ROW()*4-1) and copy down
--
Gary''s Student - gsnu200772


"MB" wrote:

I have data as follows (1 thru 11 are the rows; A and B are columns)

A B
1 ADM-1
2 blank row
3 SD1
4 blank row
5 ADM-2
6 blank row
7 SD2
8 blank row
9 ADM-3
10 blank row
11 SD3
and so on... How do I move the data so the SD#'s are next to the ADM# above
it, to be:

A B

1 ADM_1 SD1
2 ADM_2 SD2
3 ADM_3 SD3

I am using 2003.

Thank you!


--