While it is easy to use Excel to transpose rows into columns, I’ve created an AutoHotkey script which negates the need to. Basically it examines what is on the clipboard and replaces tabs with line breaks, then it sends paste to the program thus it is transposing clipboard content. I have it triggered of hitting a hotkey and comes in pretty handy and can save some time if it is something you do frequently.
Below is a video which demonstrates it usage.
^+t:: ;Control, Shift and T trigger script StringReplace, clipboard, clipboard,%A_Tab%, `r , All ;replace all tabs with line return SendPlay,^v ;send "paste" Return