Insert new row

[praveenchola]

I have a string column data and need to add new blank row after every 100th row and after new Code starts, is there any possible way to get this outcome.

[ChrisTX]

See if the attached workflow works for you.

 

Chris

[binuacs]

@praveenchola another way of doing this with the batch macro

[praveenchola]

Thanks Chris, I'm trying to implement this workflow on multiple columns but not getting the same result. What changes do I need to do ? 

[ChrisTX]

Use the Multi Field Formula tool with the RegEx_Replace function.

[binuacs · Accepted solution]

@praveenchola updated the workflow with your input file