There’s no need to re-enter all that data.
Just use Excel’s Transpose feature.
opt for cells containing the headings and data you want to transpose.
smack the “Copy” button or press Ctrl+C to copy the selected cells.
Click a blank cell where you want to copy the transposed data.
The cell you select becomes the top, left corner of whatever you’re copying.
Note that your original, pre-transposed data still exists.
you’re free to select those cells again, and delete them if you want.
