Parse Columns into Rows without affecting other columns

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.

help.yxmd

Transformation

Accepted answers

atcodedog05

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 😀👍

help.yxmd

All comments

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.