Repeating First Row After Each Change In A Certain Column

[BrandonS4]

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.

Customer	Amount	State
ABC Inc	1,500.00	CA
Tester 1	2,500.00	CA
Tester 2	2,160.00	NY
12234 Co	987.00	FL

This is what I want the data to look like:

Customer	Amount	State
ABC Inc	1,500.00	CA
Tester 1	2,500.00	CA
Customer	Amount	State
Tester 2	2,160.00	NY
Customer	Amount	State
12234 Co	987.00	FL

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

Thanks!

[binuacs]

@BrandonS4 One way of doing this with the batch macro

[ShankerV]

Hi @BrandonS4 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

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