Inbound Matrix

Hello Folks,

I am currently trying to create a matrix that takes a list of inbound vehicles & where they are coming from and sorts them into a matrix and shows the time they are due in.

I have been stuck on this, i need it to be able to pull from a list of inbound trunks and update the matrix accordingly.

If anyone could help with this it would be fantastic


Capture.PNG

I have updated the picture, i have put the data to the right of the matrix i am looking to create, although this would be exported from software and posted into a Data sheet for the matrix to take data from.

Can you attach a sample file with before and after data?