As user Sux2Lose has mentioned, there is not necessarily a native method of transposing this data in Excel. There is, however, a way to utilize a word processor for this task. (MS Word, TextWrangler, Notepad++, etc)
I assume that the data is currently in the same row across multiple columns, and you are trying to take that same data and format it in Excel across multiple rows. If you copy this set of data into your word processor, the table is lost, but the tab spacing remain. At that point, you can do a find and replace to change the tab spacing into new line spacing
Find: ^t in word, \t in other word processors
Replace: ^p in word, \r or \n in other word processors
Once you do this, you will be able to paste your data back into Excel in the appropriate format.