Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?
Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?
مندرجہ ذیل میں سے کون سا فنکشن مائیکروسافٹ ایکسل میں کالموں اور قطاروں کے مواد کو کالموں میں گھماتا ہے؟
Explanation
The purpose of the TRANSPOSE function in Excel is to convert rows to columns,
i.e. switch the orientation of a given range from horizontal to vertical or vice versa.
The function takes just one argument:
TRANSPOSE(array)
Where array is the range of cells to transpose.
ND29-5-2023