Suppose we have a data which needs to be rotated i.e. the rows should become the columns and vice versa. How would we do that?
One method is , to create a new sheet and start doing this manually but would that be an efficient solution. What if the report is too big like 1000 lines or so.
Click on the TRANSPOSE CHECKBOX on the lower right bottom of the dialog box.
The table can also be rotated using a function.
This can be done with the use of a function named as TRANSPOSE FUNCTION. [ CLICK HERE FOR FULL INFORMATION]
For a review the syntax ( the way how formula is phrased for excel) of MATCH is
=TRANSPOSE(ARRAY OF CELLS)
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE