Switching the axis

Hello everyone

I'm working with a program that generates excel files, but it generates all the data in a single x line (240 cells).

So basically I have my data spread in cells as follows: A1,B1,C1...

Is there anyway to change the axis so that instead of one long line of data along the X axis I'll have all of the data arranged along one Y column?
So I'll have the cells: A1,A2,A3...?

Thanks in advance.