Question: how to transfer data from a row to a column in excel?
Answer: Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C. ... 
Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data.