Many Text to column

[TRM]

Hello

I don't know how to solve this issue, i hope you can help.

My file is attached below. The current model works, and gives the correct result. My problem is that i might have testHeader with a test4 coming in, and then it doesn't work, i will have to add another Text to column and specify the column, how can i make this more general, so it works with test'N' inputs?

Thanks in advance.

Best regards Theis

[Qiu]

@TRM 
An iterative macro should do the trick.

[TRM]

Thank you Qiu

It looks like the solution would work, but i can't tell from the pictures what you are doing, i downloaded the attachment you sent but it looks like this:

Can you send the other macro you are using too?

Many thanks

TRM

[Qiu · Accepted solution]

@TRM 

Sorry It did not work. here is the macro I have created.

Ps: if you do mention, by typing a @mark, I will be notified.

[TRM]

@Qiu 

Thank you very much it works great now.

Thanks for the tip.