Transpose Paste in Excel
Transpose paste will save you time flipping the rows and columns of data in a spreadsheet without having to manually copy and paste.
Step 1: Ctrl A to select data you want to transpose
Step 2: Ctrl C to copy the data
Step 3: Select the cell where you want the transposed data to be pasted. Then right click & select Transpose from Paste Options