columns to rows

[thetank]

How do I transfer a column of names into a row?

 

[a7n9]

Do you mean something like Paste Special>Transpose? or something different?

 

[thetank]

That didn't work. I have a column of about 28 names and I would like to convert them into a row.

Thanks for your help.

 

[a7n9]

Not like this??

Book2
	A	B	C	D	E	F
1
2	A		A	B	C	D
3	B
4	C
5	D
Sheet1

 

[Aladin Akyurek]

That didn't work. I have a column of about 28 names and I would like to convert them into a row.

Thanks for your help.

Edit|Copy the names range.
Select a destination cell.
Edit|Paste Special >Transpose

 

[thetank]

Thanks