I am trying to use the split flatten function with no success.

This is the data set

I tried to change the data to look like this

But when I tried to use the formula, the data doesn’t come out right.

Data sample

Could anyone help me figure out what I did wrong, please? Thank you.