Copying data in to a row instead of a column

[jeskit]

Hi

Does anyone know how to copy data into excel so it goes along the columns in one row instead of copying into one column?

For example instead of pasting data into one column so it goes down the column like:
1
2
3
4
5
6
but have it go along the columns in one row like
1 2 3 4 5 6 7 8

I hope this make sense, not sure how to ask the question

Thanks

Jeskit

[TMS]

If it's data you are copying from another location, you can use PasteSpecial | Transpose


Regards

[jeskit]

Thank you very much works now!