Create new columns in front of columns with certain prefix

[Mtvbqb]

Hello,

I have a data set where the number of fields will shift dynamically. I need to place an empty column in front of columns that contain one of two prefixes.

Example:

Name	ID	ABC_923	ABC_928	Total	XYZ_876	XYZ_572

Would be transformed into this:

Name

ID

ABC_923_2

ABC_923

ABC_928_2

ABC_928

Total

XYZ_876_2

XYZ_876

XYZ_572_2

XYZ_572

Any help would be hugely appreciated. Thanks!

[AbhilashR]

@Mtvbqb - does the attached solution work as an acceptable solution in your case?

[Greg_Murray · Accepted solution]

@Mtvbqb 

This was a little tricky. I am sure there are better solutions out there, but this worked for me. 

see attached.

-Greg

[AbhilashR]

@Greg_Murray - I love the way you managed to programatically get your column order intact. Definitely using this approach in my day-to-day work!

[Greg_Murray]

@AbhilashR Thanks! I had to ponder on it for a bit.

[Mtvbqb]

Thanks for the solution! This is exactly what I struggled all morning to achieve!

Keeping the column order was vital, so thanks again for that!

[grossal]

I know I am a bit late, but I want to post my result anyway 😉

I came up with a similar approach to @Greg_Murray but was able to save some tools.

Workflow is attached.

Alex