Need ideas on expanding running numbers from symbol

[jlvi]

Hi there i am looking for ideas to do the following Alteryx:

On the left is the original column i have, would like to expand them into the right column. (in one column, the table coloring just shown for ease of understanding).

Attached the data in excel file below.

Thanks and appreciate any ideas suggested.

Left: original column, right: expected output

[gawa]

Hi @jlvi

From the given dataset and explanation, I'm not sure I fully understand the context, but please refer to the attached workflow.

Was this what you wanted to do? If no, with reference to this, please finish your task!

Spoiler