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.