Concatenate columns dynamically

mihaicom20

Hello,

I am wondering if there is a smart way or dynamic way to concatenate multiple columns, based on specific condition: all columns after a specific one until another specific column.
Formula Tool can't do the trick if the number column is varying, so the formula needs to be modified each time.

As an example I would like to concatenate all Columns after "Short text" up to "Matl Group", that may vary from input to input.The short text was split from a CVS file and for some rows the "TAB" delimiter was found on the data and that is why there are many columns.  Sometimes I can have 5 Field and sometimes 20 Field.  

As a small help: I can move the Text Column at the end of the export and all the "Field*" to be at the end generated.

Thanks in advance.

atcodedog05

Hi @mihaicom20 

Sorry for the delay i must have missed it somehow.

You merge columns dynamically like this.

Now you need to tell me how are they split. Column order in expected output is not the same as input column order. Please provide exact mapping to split.

Hope this helps : )

merge data.yxmd