ExcelBanter - how do i tranpose one row to multiple column?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i tranpose one row to multiple column? (https://www.excelbanter.com/excel-worksheet-functions/47594-how-do-i-tranpose-one-row-multiple-column.html)

ALEX

how do i tranpose one row to multiple column?

I HAVE A ROW WITH ADDRESSES IN FORMAT
A
B
C
D
BUT I WANT TO TRANSPOSE TO LOOK LKE THIS
A B C D

David Billigmeier

Copy the records then... Right Click-Paste Special-Transpose

--
Regards,
Dave

"ALEX" wrote:

I HAVE A ROW WITH ADDRESSES IN FORMAT
A
B
C
D
BUT I WANT TO TRANSPOSE TO LOOK LKE THIS
A B C D

All times are GMT +1. The time now is 08:29 PM.