Have you tried the TRANSPOSE function?
Find it under Home TAB/Paste drop-down/Transpose

You highlight the entire range (or you can do a row at a time, up to you), copy/paste Transpose