formula for multiple split headers of text and numbers to respective headers

I have an extract of data list which has columns of multiple numbers and text which are separated by a comma .

my goal to split header of columns A , to their respective headers which has multiple numbers and text.

Some have one description , others have multiple code numbers and description which need to be split .

All numbers consists of 8 digits only , but description varies in length eg powder (aaaa s113)