Buzz
This article below provides detailed instructions on how to convert rows to columns and vice versa in Excel.
Assume we have the following dataset, where attributes are currently arranged in rows and we want to convert them into columns.
Step 1: Highlight the data range you want to convert to columns -> right-click -> Copy.
Step 2: Right-click at the position of the new table you want to display, then select Paste Special.
Step 3: A dialog box will appear; check the Transpose option, then press OK to complete the process.
The result is that the attributes are transformed into column headers (as shown in the diagram):
If you wish to convert columns into rows, perform similar steps.
Wishing you all success!
