Wannabeexcelguru
New Member
- Joined
- Aug 18, 2015
- Messages
- 4
Hi All,
I have table which have sales located from different countries and the contact person.
It's possible to do pivot table that shows the country (first column), cities (second column) and the contact persons (third column)?
Below is a sample what I want.
<colgroup><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
Thank You!
I have table which have sales located from different countries and the contact person.
It's possible to do pivot table that shows the country (first column), cities (second column) and the contact persons (third column)?
Below is a sample what I want.
| Master Data | Pivot table by Countries | Pivot table by Countries | Pivot table by Countries | |||||||||||
| Country | City | Name | Country | City | Name | Sweden | Stockholm | John | Denmark | Herning | Mark 5 | |||
| Finland | Helsinki | Mark | Finland | Helsinki | Mark | Sweden | Stockholm | John2 | Denmark | Aarhus | Miikka | |||
| Finland | Turku | Steven | Finland | Turku | Steven | Sweden | Stockholm | John3 | Denmark | Copenhagen | Matti | |||
| Sweden | Stockholm | John | Sweden | Sandviken | Mark 1 | Denmark | Copenhagen | Juuso | ||||||
| Sweden | Stockholm | John2 | Denmark | Copenhagen | Kari | |||||||||
| Sweden | Stockholm | John3 | ||||||||||||
| Sweden | Stockholm | Mark 1 | ||||||||||||
| Denmark | Herning | Mark 5 | ||||||||||||
| Denmark | Aarhus | Miikka | ||||||||||||
| Denmark | Copenhagen | Matti | ||||||||||||
| Denmark | Copenhagen | Juuso | ||||||||||||
| Denmark | Copenhagen | Kari |
<colgroup><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
Thank You!
