Copying vertical information from one sheet to another but posting it horizontal

Hello,

First time posting here. Not sure the best way to word this. I have an worksheet with information running down 1 column 'J' for around 300 rows. I want to copy the numbers from the Column and put them in another worksheet but have the numbers running in a row. Is this possible and if so how?

After copying them and going to the destination sheet, choose Paste Special and then Transpose. Alternatively press Alt H V T in sequence.

Welcome to the forum.

The information in your profile does not precisely convey your Excel version, so I assume it is 2016.
That being said, assuming your data starts in cell A1, please try in a blank cell of your choosing and copy across:

Formula:

Please Login or Register  to view this content.

If that does not work, please follow instructions on yellow banner above to upload a sample wb.

Good luck!