They convert the results of the expression ... It’s the same as the earlier BYCOL() example, but it evaluates rows instead of columns. Excel’s LAMBDA() function can handle complex calculations.

The rows are switch to columns. We hope this tutorial helps you understand how to switch rows and columns in an Excel Chart. Read next: How to use the DVAR function in Excel.

Microsoft is testing a new feature that highlights the active row and column when a cell is selected. This means it's easier to follow across rows and down columns when reading your data.