How to split output to excel based on number of columns?

[Rod1274]

this is my scenario...

thanks for the help.

[alexnajm]

Looks like a macro will be your best option! The macro can affect a Dynamic Select tool where you can use [FieldNumber] or [Name] as the parameter to filter 1-5, 6-10, 11-15, etc.

I am a bit hesitant to try building something because I'm concerned there may be more than meets the eye, so hopefully that gives you some direction!

[Qiu · Accepted solution]

@Rod1274 

I also tried with a Batch Macro but with Transpose and Cross Tab tools.
I divided the columns in to Groups based on the Number which can be written or added as a Constant.

[Rod1274]

Thanks you !!! Very nice solution.