If you are unaware of it, Excel supports a one-click operation to swap rows, columns, or ranges quickly, known as Transpose. Transpose Row to Column in Excel.