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