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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback