Change table format from data in cell

Hi everyone,

I have the input like this:

I want to make a huge change in the format, I tried to split it but some how it doesn’t work.

This is the output I want.

I appreciate all your help.

Thank you very much.

EDIT: Outside KNIME, can it be done in excel guys?

draft test.xlsx