When creating a report, there will sometimes be a need to rearrange rows and/or columns into a form suitable for reporting. Previously, you had to do this manually, and now there are two functions that can make the said job easier for you. They are named WRAPROWS and WRAPCOLUMNS. Let’s see how you can “wrap” the data in a way that suits you.
The TRANSPOSE function has been around for a very long time and allows you, when working with formulas containing arrays, to transpose them from row to column or vice versa. A similar effect can be obtained using the Paste Special option. Since recently, Excel offered to users through Microsoft 365 subscription, has functions TOROW and TOCOL with which we can easily convert rows into columns and columns into rows…