Excel data from Column to Row

[Kevin]

I've got a bunch of data that is all in a single column.
Is there any way to get it to display in a row??

I just basically want to take data from b3->c2, b4->d2, b5-

e2, etc.

Thanks in advance

Kevin

 

[Juan Sanchez]

Kevin...

Copy then:

Edit > Paste Special > Transpose (bottom left)

Cheers
Juan

 

[Max]

One way ..

Put in C2: =OFFSET($B$2,COLUMN(A:A),)

Copy C2 across as required ..

 

[Patti]

Try Copy, Paste Special, Transpose

-----Original Message-----
I've got a bunch of data that is all in a single column.
Is there any way to get it to display in a row??

I just basically want to take data from b3->c2, b4->d2, b5-

Thanks in advance

Kevin
.