Hey Everyone,

Here is my dilema. I have a spreadsheet that all of its data is in column A. Like this.

1. Question
A. Red
B. Blue
C. Black
D. Yellow
2. Question
A. Green
B. Red
C. Purple
D. Brown
3 Question
A. Orange
B. Green
C. Blue
D. Blue

And I need to move the Answers to look like this.

1. Question A. Red B. Blue C. Black D. Yellow
2. Question A. Green B. Red C. Purple D. Brown
3. Question A. Orange B. Green C. Blue D. Blue

I hope I can accomplish this with a formula but I am thinking it may have to be a macro and I am very inexperienced when it comes to macros. Which by the way original column is 720 entries long. So I am trying to not sit for hours manually Cutting and pasting the cells where I need them. Thanks for all your help.