Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D
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 |