Transpose

Transpose is the process of swapping rows into columns and vice versa. This can be performed on some particular column or row as per the user’s preferences. This gives a varied three-dimensional view on the records.

         

The transpose is set on a **first_name **basis.

         

The records are now represented on first name basis of the employees.

         

However, transpose allows just the top 500 records to be fetched while performing transpose operation.