Converting concatenated values into rows - Cross Tab tool

[AltAddict26]

Hi - I am looking to create multiple rows out of one concatenated row. The image below outlines what I am tying to accomplish - any insights here would be mush appreciated!

[BradWerner · Accepted solution]

Hi @AltAddict26,

How about this?

Let me know if this works for you or if you have any questions!

Brad

[BradWerner]

Does your data come in different formats or amounts that you might need to take into consideration?

Just curious,

Brad

[AltAddict26]

I ended up getting this to to work with a multi-row tool and a cross tab tool - I love see how many ways there is to solve this. Thanks for looking into this!