Extract data from text string

Hello there, I have attached my example workbook. In cell A1 I have a text string, with a comma separating each entity.

I would like to extract and stack each entrant as shown in the example. So the name will appear in B and the price in C.

Could someone help with the formula needed to extract and order in this way from the text string in A1

This is not that easy using formulas. I would either approach it with VBA or text to columns.

With text to columns:
-select A1 and use the text to columns tool with ", " as a delimiter
-copy the resulting row and pastespecial using transpose to change from rows to columns
-select the resulting column and use " " as a delimiter

for a macro, either record the above process as a macro. Or use the VBA split function to manipulate the data into the correct array first before assigning to your range.

Thanks all for your suggestions and help. I can work with it having the odds first