Question: how to move data in rows to columns?
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.