Arranging data sets in Excel reports can sometimes get complicated, for example when you are editing a list of visitors to your stand at a business fair or congress. Then we usually manually copy the lists, merge them, and further remove duplicates. Excel has some new functions that allow you to literally do this procedure in a couple of steps, and in the following “recipe” you will find out how to apply them in practice.
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…