changing column data to row data and vice versa

[blahbot2000]

Have a program that outputs data into rows, but need to put it into another program that only accepts data in columns, is there a way to "rotate" information in excel like this without having to completely re-enter the data by hand?

 

[anno]

copy then paste special>transpose