Transposing

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

(Blank Cell)

CASCADE GROWERS LLC
AARON DUNLAP
5127 MILE HILL DR
PORT ORCHARD
WA
98366

(Blank Cell)

GAFCO LLC
HARRIS & MOURE, PLLC
600 STEWART ST # 1200
SEATTLE
WA
98101

(Blank Cell)

GEORGE WASHINGTON HEMP COMPANY
PAUL RAMSAY
6636 CARLETON AVE S
SEATTLE
WA
98108

(B) Format Needed

WASHINGTON STATE PRODUCER RICHARD ANDERSON 8067 SW GLENWOOD RD PORT ORCHARD WA 98367
AMERICANNA NATURALS HARRIS & MOURE 600 STEWART ST STE 1200 SEATTLE WA 98101
CASCADE GROWERS LLC AARON DUNLAP 5127 MILE HILL DR PORT ORCHARD WA 98366
GAFCO LLC HARRIS & MOURE,PLLC 600 STEWART ST # 1200 SEATTLE WA 98101
GEORGE WASHINGTON HEMP COMPANY PAUL RAMSAY 6636 CARLETON AVE S SEATTLE WA 98108

AttachmentSize
A.xlsx8.55 KB
B.xlsx8.48 KB
Vikas Verma's picture

Please visit

Hi Dear,

Please Visit the below mentioned...

http://excelexperts.com/node/add/blog

Thanks & regards,
Vikas Verma