I have address data is column C on an Excel spreadsheet. It is formatted
like a normal address in rows within that column and two blank cells between
each address. I need a macro to copy the address--paste special--transpose
in a different sheet and then go back and find the next address and do the
same thing. Below are some example of the addresses. They can contain up to
six rows, but some do not have the second street address line.

MACHINERY CORP.
SERVICE MANAGER
555 STATE STREET
P.O.BOX 12345
WAIPAHU, HI 96797
USA


EQUIPMENT CO INC
SERVICE MANAGER
555 W SPRING DR
P O BOX 123
BUTLER WI 53007
USA


EQUIPMENT CO INC
SERVICE MANAGER
55555 WHITE RD

MADISON WI 53716
USA