BYROW Function Explained
The BYROW function in Microsoft Excel is used to transpose a matrix, or an array of data, by switching the rows and columns. This means that the first row of the original matrix becomes the first column of the transposed matrix, and the first column of the original matrix becomes the first row of the transposed matrix.
BYROW Function Syntax
BYROW(array, row_num, column_num)
- array: The range of cells to be evaluated.
- row_num: The row number of the cell to be returned.
- column_num: The column number of the cell to be returned.