Can I use a pivot table to get the result shown below? How can I get the row labels for each sales agent and have add a blank row after each sales agent.
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
thanks for your help and time
Sales person Name 1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
Product Item Number | 10 | 20 | 15 | 13 | 12 | 10 | 20 | 10 | 11 | 15 | 16 | |
Product Item Number | 10 | 5 | 11 | 15 | 12 | 6 | 18 | |||||
Product Item Number | 10 | 6 | 10 | 12 | 12 | 5 | 12 | 12 | ||||
Product Item Number | 10 | 2 | 8 | 10 | 3 | 10 | ||||||
Product Item Number | 10 | |||||||||||
Total Current Region Product | 50 | 33 | 44 | 50 | 36 | 24 | 60 | 22 | 11 | 15 | 16 | 0 |
South East Product | ||||||||||||
Product Item Number | 10 | 15 | 5 | 6 | 5 | 3 | ||||||
Product Item Number | 20 | 20 | 2 | 4 | 2 | |||||||
Product Item Number | 5 | 2 | ||||||||||
South East Product Total | 30 | 35 | 12 | 10 | 9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
North West Product | ||||||||||||
Product Item Number | 10 | 12 | 5 | 10 | 8 | 12 | 10 | 11 | 10 | |||
Product Item Number | 20 | 10 | 12 | 10 | 5 | 6 | 8 | 10 | ||||
Product Item Number | 10 | 8 | ||||||||||
North West Product Total | 40 | 30 | 17 | 20 | 13 | 18 | 18 | 21 | 10 | 0 | 0 | 0 |
TOTAL | 120 | 98 | 73 | 80 | 58 | 45 | 78 | 43 | 21 | 15 | 16 | 0 |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
Sales person Name 2 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
Product Item Number | 10 | 20 | 15 | 13 | 12 | 10 | 20 | 10 | 11 | 15 | 16 | |
Product Item Number | 10 | 5 | 11 | 15 | 12 | 6 | 18 | |||||
Product Item Number | 10 | 6 | 10 | 12 | 12 | 5 | 12 | 12 | ||||
Product Item Number | 10 | 2 | 8 | 10 | 3 | 10 | ||||||
Product Item Number | 10 | |||||||||||
Total Current Region Product | 50 | 33 | 44 | 50 | 36 | 24 | 60 | 22 | 11 | 15 | 16 | 0 |
South East Product | ||||||||||||
Product Item Number | 10 | 15 | 5 | 6 | 5 | 3 | ||||||
Product Item Number | 20 | 20 | 2 | 4 | 2 | |||||||
Product Item Number | 5 | 2 | ||||||||||
South East Product Total | 30 | 35 | 12 | 10 | 9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
North West Product | ||||||||||||
Product Item Number | 10 | 12 | 5 | 10 | 8 | 12 | 10 | 11 | 10 | |||
Product Item Number | 20 | 10 | 12 | 10 | 5 | 6 | 8 | 10 | ||||
Product Item Number | 10 | 8 | ||||||||||
North West Product Total | 40 | 30 | 17 | 20 | 13 | 18 | 18 | 21 | 10 | 0 | 0 | 0 |
TOTAL | 120 | 98 | 73 | 80 | 58 | 45 | 78 | 43 | 21 | 15 | 16 | 0 |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
thanks for your help and time