I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
How-To Geek on MSN
How to Use the TOCOL and TOROW Functions in Microsoft Excel
The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and columns using the TRANSPOSE function, transform large datasets using ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback