I have some 10k lines in both VAN and SHOPS column. Sometimes the Vans go to wrong shop so I would like to know how many times a van went to a certain shop .
Source:
<tbody>
</tbody>
The result should be like this
<tbody>
</tbody>
Pivot table consists of blank cells so I can't do further data manipulation. At the moment I can't use any formulas using arrays, it just shows the formula, tried all solutions found by google incl ctrl+ ', no-text format, click to the formula, check {} etc.
Anyone can help, without using arrays?
Source:
Date | VANS | SHOPS |
30/11/2017 | VAN1 | SHOP1 |
30/11/2017 | VAN1 | SHOP2 |
30/11/2017 | VAN1 | SHOP1 |
30/11/2017 | VAN1 | SHOP3 |
30/11/2017 | VAN1 | SHOP1 |
30/11/2017 | VAN2 | SHOP4 |
01/12/2017 | VAN2 | SHOP4 |
01/12/2017 | VAN2 | SHOP5 |
01/12/2017 | VAN2 | SHOP6 |
01/12/2017 | VAN3 | SHOP7 |
<tbody>
</tbody>
The result should be like this
VAN1 | VAN1-SHOP (cases) | VAN2 | VAN2-SHOP (cases) | VAN3 | VAN3-SHOP (cases) |
SHOP1 | 3 | SHOP4 | 2 | SHOP7 | 1 |
SHOP2 | 1 | SHOP5 | 1 | ||
SHOP3 | 1 | SHOP6 | 1 |
<tbody>
</tbody>
Pivot table consists of blank cells so I can't do further data manipulation. At the moment I can't use any formulas using arrays, it just shows the formula, tried all solutions found by google incl ctrl+ ', no-text format, click to the formula, check {} etc.
Anyone can help, without using arrays?