Removing Merged cells keeping entries order

Good morning

I would like to know how to transform the Table present in Column A in the one in Column C, see attached file:

Example table.xlsx

Thanks in advance

Maybe something like this? Using array formulas........


regards