Repeating First Row After Each Change In A Certain Column

Question

I am wanting to repeat the first row of my data after each change in a certain column.  I have an example below of what the first row is.  After each change in state, I want to repeat Customer, Amount and State.

CustomerAmountStateABC Inc   1,500.00CATester 1   2,500.00CATester 2   2,160.00NY12234 Co      987.00FL

This is what I want the data to look like:

CustomerAmountStateABC Inc   1,500.00CATester 1   2,500.00CACustomerAmountStateTester 2   2,160.00NYCustomerAmountState12234 Co      987.00FL

So how do I repeat the first row after each change in state?

Thanks!

ShankerV · Answer

Hi @BrandonS4

Step 1: Input

Step 2:

Step 3:

IF [State]=[Row-1:State]
THEN 0
ELSE 1
ENDIF

Step 4:

Step 5:

Step 6:

Step 7:

Step 8:

Step 9:

Step 10:

Many thanks

Shanker V

ShankerV · Answer

Hi @BrandonS4

One way of doing this.

Many thanks

Shanker V

binu_acs · Answer

@BrandonS4 One way of doing this with the batch macro

Repeat_Header_010523.yxzp