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

Hi everyone, i'm having difficulty deciding how to approach my problem here. I have two colums of data, the first w/ an id, and the second having a comma-delimited string of other ids (see image w/ five rows of data). What i need to do is get get rid of the csv string, and create the data into two columns, each with no more than 1 id therein, as within the image w/ 16 rows of data.

Basically, i need one record for each Track_id to PSplit_id relationship

I'm getting nowhere w/ functions, as they don't seem to create rows of data, and I'm completely unfamiliar with pivots (someone tome me this could help). I'm starting to think i'll need to import the data into an Access table, and run a query to get the results how i need, then import the query results back into Excel. Is this the best approach, or is it possible without having to resort to Access?

Any advice is appreciate, thanks!
Chris