Need to transform name and address from vertical rows to columns accross

[induna]

By highlighting and copying a name and address in a block format, I then paste it to an XL spreadsheet the result of course is everything all goes into one column.
How can I (easily) force the result to occupy separate columns IPO rows?

[NBVC]

Try doing Paste Special instead, then select Transpose.

[induna]

Thanks That worked