I'm trying to transpose (A) to (B), but every time I do this it just strings the text across one row. I need each address to to be read horizontally in a row with a blank cell between each address in the column. I have 1155 address in the column I don't want to transpose one at a time. I want to copy all 1155 address and have them transposed in the format I need. See (B) Format Needed

(A) Existing

WASHINGTON STATE PRODUCER
RICHARD ANDERSON
8067 SW GLENWOOD RD
PORT ORCHARD
WA
98367

(Blank Cell)

AMERICANNA NATURALS
HARRIS & MOURE
600 STEWART ST STE 1200
SEATTLE
WA
98101