Thanks for this John, to accompany your helpful links I’ve created a PHP function which transforms the comma separated string into an array which matches the format of a repeater. The gist and a more detailed explanation are here:
Comma separated string into ACF compatible multidimensional array
Posting in case it helps anyone else.