Depending on the amount of data you have to process, this might not be useful.

If your data is in rows like in the example it will be pasted into excel also in rows, which means you can use the TRANSPOSE function to transform it into columns.

Lets assume your data is in range A1:A5

Select your column range and use this formula =TRANSPOSE(A1:A5) then push Shift+Ctrl+Enter without exiting the formula and the data from the rows will be transformed into columns.