The dataset looks like this, as it gets form submissions:

Then, the requirement is that the columns after column B get transposed, while splitting the cell values by the comma and also transposing and repeating the column headers, so that it looks like this:

I have this file for tests, in case you feel like helping out. My attempts fail, as I cannot wrap my head around more advanced functions like lambda, map, etc.