Need help with extracting data without using Array-function

[zulkir]

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:
[TABLE="width: 215"]
<tbody>[TR]
[TD]Date[/TD]
[TD="align: center"]VANS[/TD]
[TD="align: center"]SHOPS[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN1[/TD]
[TD="align: center"]SHOP1[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN1[/TD]
[TD="align: center"]SHOP2[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN1[/TD]
[TD="align: center"]SHOP1[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN1[/TD]
[TD="align: center"]SHOP3[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN1[/TD]
[TD="align: center"]SHOP1[/TD]
[/TR]
[TR]
[TD="align: center"]30/11/2017[/TD]
[TD="align: center"]VAN2[/TD]
[TD="align: center"]SHOP4[/TD]
[/TR]
[TR]
[TD="align: center"]01/12/2017[/TD]
[TD="align: center"]VAN2[/TD]
[TD="align: center"]SHOP4[/TD]
[/TR]
[TR]
[TD="align: center"]01/12/2017[/TD]
[TD="align: center"]VAN2[/TD]
[TD="align: center"]SHOP5[/TD]
[/TR]
[TR]
[TD="align: center"]01/12/2017[/TD]
[TD="align: center"]VAN2[/TD]
[TD="align: center"]SHOP6[/TD]
[/TR]
[TR]
[TD="align: center"]01/12/2017[/TD]
[TD="align: center"]VAN3[/TD]
[TD="align: center"]SHOP7[/TD]
[/TR]
</tbody>[/TABLE]


The result should be like this
[TABLE="width: 580"]
<tbody>[TR]
[TD]VAN1[/TD]
[TD]VAN1-SHOP (cases)[/TD]
[TD]VAN2[/TD]
[TD]VAN2-SHOP (cases)[/TD]
[TD]VAN3[/TD]
[TD]VAN3-SHOP (cases)[/TD]
[/TR]
[TR]
[TD]SHOP1[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]SHOP4[/TD]
[TD="align: center"]2[/TD]
[TD]SHOP7[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]SHOP2[/TD]
[TD="align: center"]1[/TD]
[TD]SHOP5[/TD]
[TD="align: center"]1[/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]SHOP3[/TD]
[TD="align: center"]1[/TD]
[TD]SHOP6[/TD]
[TD="align: center"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[zulkir]

Thanks all!

 

[admiral100]

You are welocme. Thank you for the feedback.