Question: how to transfer data from a column to a row in excel?
Answer: Open Excel and choose Blank workbook.
Enter the data you'd like to shift around from a column to a row (or vice versa).
Copy the entire data set by selecting each the area, right-clicking, and selecting Copy.