Creating a new column based on certain criteria

[CCrawford94]

I need to add a reference column to my data after every Field name that contains "123". The below data is how i would expect it to look when it comes out please let me know if you can help. Im trying to make this dynamic because in the field i am in i will be receiving multiple different columns but they will always have 123 in the name.

Car123	Ref	bag123	Ref	Dog123	Ref

Any help is greatly appreciated!

Thanks

[BenMoss · Accepted solution]

Here's one way to approach the problem (attached), but it's important to note it won't be possible to get your desired result exactly as you cannot name multiple columns with the same name in Alteryx.

The attached example also doesn't take into account the sort order, if that's something that you need to get right let me know and I can ammend the logic accordingly!

Ben

[BenMoss]

And here is a version that gives the position after the current field.

Ben

[CCrawford94]

Thank you for both replies these worked great!