Function TRANSPOSE
Transpose Whole Excel Sheet. Go to a new worksheet and paste, transpose. Select all the data (not the whole worksheet) and copy.
Select all the data (not the whole worksheet) and copy. Go to a new worksheet and paste, transpose.
Select all the data (not the whole worksheet) and copy. Select all the data (not the whole worksheet) and copy. Go to a new worksheet and paste, transpose.