What is the functionality of the 'Transpose' option included in the 'Paste Special’ dialog box of MS Excel 2016?
1
It changes the orientation of the copied range
2
It is used to copy only formatting
3
It is used to copy everything except the formatting
4
It is used to merge conditional formatting from source to destination