I need to monitor asset tags for a very large company and need to create a table to show what machine types are at each location

The problem i have is that the machines are tracked through a repair loop and can be sent to another site with in weeks so the data is spread over a number of cells up to a maaximum of 7 moves

I need to pick up the site ID after the UKD from any of these 7 possible move records and then create a pivot table to show the type count by this location number

[type (could be server, till, email, word processor, LAPTOP ) etc
serial number 1234567abc
Initial location UKD99999-000
date 1st move whenever 0
1st location UKD99998-001
date 2nd move whenever
2nd location UKD99998-000 ETC ALL THE WAY TO 7TH LOCATION


So the finished table looks somthing like below

]site Server Till Email W/Processor Laptop
99999 1 1 1 1 1
99998 1 1 0 0 0
99997 1 1 0 1 1

obviously the various counts would depend on the type count