Question: how to move data from 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.