How to deal with split rows

[anad]

Hi,

I was wandering if anyone knows how to deal with split rows.  My data looks like this:

and I would like it to look like 

Thank you so much,

Ana

[JosephSerpis · Accepted solution]

Hi @anad I mocked up a worklfow that I think answers your question. Let me know what you think?

[anad]

Thank you very much that did it!