I am having a problem figuring out a macro to transpose 6500 rows of
name & address in clumps of 4 rows each in column A separated by 4
blank rows like this:

First and Last Name
123 Any Street
My Town, CA
90224
blank row
blank row
blank row
blank row
First and Last Name
222 Maple Avet
Big City, CA
90238
etc

to columns in a new worksheet that will look like this:

column     A                       B                          C
     D
First and Last Name    123 Any Street    My Town, CA     90224
First and Last Name    222 Maple Ave     Big City, CA      90238

Can anyone write a macro to accomplish this please?

Thank you in advance!!

Keith