Karan 01/06/1987 A Justin 09/08/1964 D Bob 04/05/1996 B Jason 08/09/1984 C. In this case, you may want to organize the data in the sequence of Name, DOB, and Grade across rows and columns and not ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

The same feature allows you to convert horizontal row data sheets into vertical column style sheets. The feature works with all recent versions of Microsoft Excel, including Office 365.