Split out a cell into multiple rows but copy other cell information on the same row

[DataMarsh]

Hi Community,

Newbie question here, I need to split this column into multiple rows:

Any idea on how this can be achieved in Alteryx? 

I have attached an Excel with example data and the desire output as well. 

Any help would be appreciated. TIA

[FinnCharlton]

Hi @DataMarsh , here is a quick way to do this:

Hope this helps!

[binuacs]

@DataMarsh One way of doing this