Split Comma Delimited Field to Rows in a query

[templeowls]

So I have a database table with a comma delimited field that I need to split into multiple rows. See below example:

ID Text
1 Peter
2 Peter, George
3 Mike, Kelly, Jim, Jim, Jim


I need it to look like this:
1 Peter
2 Peter
2 George
3 Mike
3 Kelly
3 Jim
3 Jim
3 Jim


Any recommendations on how to do this? Any guide I have found online is hidden behind a paywall

[Micron]

You could use Split function to divide the elements into an array, then loop through the array and update a recordset. Must be free code examples for that. What did you search for? This ms access vba split string into recordset
produced 89 results with lots of sub-results
post 6 here is just one solution
https://www.access-programmers.co.uk...ecords.242856/
also post 2 here
https://stackoverflow.com/questions/...s-in-access-db
and so on.

[templeowls]

Thanks for the links. I must not have been searching the right terms, but granted, I didn't really know what to be looking for. This was one I found for instance: https://www.experts-exchange.com/que...d-to-Rows.html

[Micron]

Not sure how many here have a subscription to that site - not me anyway, so no way to view any solutions.