I have been trying to write Excel VBA code to manipulate some Excel data and have been unsuccessful.
What I want to do is the following (in plain English):


I have data that looks like this right now:


Question 1
Comment 1
Question 2
Comment 2
Question 3
Comment 3
...etc...


I would like to manipulate this data so that the VBA code goes down the column the number of rows I specify starting from the
Cell with "Question 1" in it then:
Moves each Comment line to be in the cell right adjacent to the Question cell and then:
Delete the blank row created by this move and repeat the process. The end result would look like this:


Question 1 Comment 1
Question 2 Comment 2
Question 3 Comment 3
....etc.....


Can anyone help me with the code for this?
Thanks in advance