vba to split numbers and text to their headers from a merge cell column

[JEAN1972]

I have a data sheet , the column C has a series of data description with numbers and text which are all merge in one cell.

there are 7 headers after column C , my goal to split each numbers and text to their respective headers.

The expected results are in yellow as per test sheet