TRANSPOSE FUNCTION IN EXCEL
Transpose Function in Excel
In this video tutorial, you will the understanding of ‘TRANSPOSE’ function converts a vertical range of cells to a horizontal range of cells or vice-versa.
--------------------------------------------------------------------------------------------------------------------------
What is Transpose Function in Excel?
The TRANSPOSE function is a built-in function. It takes a row and converts it into a column or a column and converts it into a row. In other words, we can say exchanging a row or a column.
Transpose Function Syntax in Excel
The function takes just one argument:
=TRANSPOSE(array)
-----------------------------------------------------------------------------------------------------------------------
Things to Remember about Transpose Formula
Make sure you select the same number of blank cells as the number of cells in source information while using the Transpose Formula.
Ensure you do not press ENTER after inserting the Transpose Formula because the Transpose function is an Array function. Instead, you should press CTRL+SHIFT+ENTER.
You can use the copy and paste feature for Transpose, which creates duplicate data. So when the values in source information change, the values are not updated.
----------------------------------------------------------------------------------------------------------
To know more about the Transpose Function in Excel, you can go to this link:
https://www.educba.com/transpose-in-e...
https://www.educba.com/transpose-form...
-------------------------------------------------------------------------------------------
Connect with us!
Youtube ► / @educba_official
LinkedIn ► / admin
Facebook ► / educba.official
Instagram ►https://www.instagram.com/educba.offi...