data wrangling matching columns

Hi. It would be useful if you could provide a reproducible example of the code that you have tried and the table (in code).

It is probably a combination of regex and splitting the columns.