Parse Columns into Rows without affecting other columns

[rimaissa]

I am trying to get this:

to look like this:

I've tried several different things but can't seem to get it to work. Usually I would just use a formula tool to combine the IDs into one field with a delimiter and then use a parse tool to parse to rows. However, this is affecting the data because it's then assigning both IDs to both file names which duplicates the data and isn't accurate. 

Any suggestions? I have the text input attached. 

[Greg_Murray]

hi @rimaissa, 

This is the route I would take. Use two select tools, deselect the attachment 1 fields in the one and deselect the attachment 2 fields in the other. Then union the results. 

Hope that helps,

Greg

[atcodedog05 · Accepted solution]

Hi @rimaissa 

You can use transpose, regex (column name and id) and crosstab to get your desired output and keep it dynamic. Even you have more columns.🙂

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[rimaissa]

@atcodedog05 Thank you, this worked perfectly and is future proofed!

[atcodedog05]

Happy to help 🙂 @rimaissa 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂