Hi,
I guess the information in that column is separate by , or spaces so you
need to do first a Text to columns , delimited, indicate the delimiters and
once you have the data in columns the transpose will work
Hope this help

"Excelchallenged" wrote:

I have exported a large database that is all in one column, how do I change
it to rows? The Copy, Paste Special, Transpose doesn't work because of the
length of the column.

Thank you!