Looping: Critical Assistance

[Kobenix]

Hello,

I am trying to build invoices utilizing a excel file and ROW A shows the billing ID and then theres several rows with the description of different pay criteria.

i am trying to make a loop to count the number of rows until the next billing id change in the excel document but having trouble understanding how to do that. 

I am utilizing desktop automate for this.

anyone have any idea? 

[VJR]

Can you post a screenshot which shows the change in pattern when the billing Id changes?

[Amitaggarwal0]

You need to take for loop and Variable

you logic will be like

for each   row in rows 

            CurrentBillingID = row[billingID]

            if(CurrentBillingID  equals PrevBillingID)

               .......

            Else

               ......  you encountered new BillingID

  PrevBillingID  =    CurrentBillingID