Three to Four Transpose (SOLVED)

[bhonick]

I have a number of addresses in 3 columns (A, B, and C)
They are in this format:
Column A Column B Row C

Row 1 Name Name Name
Row 2 Date of Birth Date of Birth Date of Birth
Row 3 Year Year Year
Row 4 Location Location Location

There are a few thousand like that. What I need to do is to be able to copy it, past special and transpose it into the next available row. Then I want to delete those original four cells, and repeat.

I would like it to look like:

Column D Column E Column F Column G
Row 1 Name Date of Birth Year Location
Row 2 Name Date of Birth Year Location
Row 3 Name Date of Birth Year Location
Row 4 Name Date of Birth Year Location

As this is happening, I would like this to delete the Data under columns A B and C.

Could someone show me how to set this up with a macro?

[FDibbins]

Hi and welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[MarvinP]

Hi bhonick,

Edit your original post and rename your thread to "Three to Four Transpose". After you do that I have a great (and easy) answer for you.
(to remind myself I called it - Three to Four Transpose.xlsx)

[bhonick]

Ok, I changed the title to my thread. MarvinP, I saw this solution you had posted earlier (http://www.excelforum.com/excel-prog...nd-repeat.html) but I could not figure out how to edit the macro for my situation. Thank you for the help.

[MarvinP]

Here is the workbook I created earlier but couldn't post until you changed your thread title.

[bhonick]

MarvinP, that is exactly what I was looking for. Thank you so much for the help.