Urgent Split and format text from cells using Excel, Google Sheet or Python

Job ID: 35808061

Budget: $10 – $30 CAD

See the screenshot, I have data in rows that I want to use as a custom splitter.

Red column is how it is right now. Green column is how it needs to be.

Final file needs to be in csv format. Can send sample data to test but need this urgently and for cheap.
Related categories: Python Excel Google Sheets