Which is best: Formula, Pivots, VBA, or query?

Wow Glenn, this is almost working for me, however only for the first 3 rows in my spreadsheet. There's actually about 500 rows of data. I've tried fiddling w/ the formulas a bit to expand the ranges within the INDEX, COUNT, and SUBSTITUTE functions however when i do it just gets hung up on the Track_id in the third row of data, 1734

I didn't know that we were allowed to attach .xlsx files to the forum but here's what i am working with so you can see the big picture. Thanks!