Assuming your data is on a sheet called "list", try this
in A1 of a new sheet, copy across to B1, and copy down:
=OFFSET(list!$A$1,ROW()*2+COLUMN()-3,)
HTH
Jason
Atlanta, GA
-----Original Message-----
Hello,
I have a rather large Excel sheet in which Row 1
contains a
Name and Row 2 the Address. This continues (Odd rows
having name, even address) throughout the entire sheet.
All the information is under column A. Is there a way to
split the information so that the odd rows stay in
column A
and the even rows move to Column B?
Thank you in advance,
Jack
.
|