Do Until Find a new value

[kfilippo]

Hello,

I have a table where in column A there are a set of data of all kinds.
In some cells of this column there is the information that interest me, that comes in the form "account - xxxx"/ then a few rows below I'll find "account - yyyy", then "account - zzzz" and so on. xxxx, yyyy, zzzz are different numbers.
I would like to perform an action usind the data of other columns and display the corresponding account number on each row of column A. I have a input sheet with raw data and an output sheet with the treated data.
So, trying to ilustrate, in my original tab I have:

A B C
account - xxxx data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
account - yyyy data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
account - zzzz data on column B data on column C

And I would like to put in another sheet in the format:

A B C
xxxx treated data on column B treated data on column C
xxxx treated data on column B treated data on column C
xxxx treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
zzzz treated data on column B treated data on column C


So I was trying to do something like a DO an action to treat the data I need while also displaying the account number xxxx on column A UNTIL account number changes to yyyy. And then until it changes to zzzz. And so on.

Can someone help me with that?

Thank you

 

[kfilippo]

Hello,

I have a table where in column A there are a set of data of all kinds.
In some cells of this column there is the information that interest me, that comes in the form "account - xxxx"/ then a few rows below I'll find "account - yyyy", then "account - zzzz" and so on. xxxx, yyyy, zzzz are different numbers.
I would like to perform an action usind the data of other columns and display the corresponding account number on each row of column A. I have a input sheet with raw data and an output sheet with the treated data.
So, trying to ilustrate, in my original tab I have:

A B C
account - xxxx data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
account - yyyy data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
.... data on column B data on column C
account - zzzz data on column B data on column C

And I would like to put in another sheet in the format:

A B C
xxxx treated data on column B treated data on column C
xxxx treated data on column B treated data on column C
xxxx treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
yyyy treated data on column B treated data on column C
zzzz treated data on column B treated data on column C


So I was trying to do something like a DO an action to treat the data I need while also displaying the account number xxxx on column A UNTIL account number changes to yyyy. And then until it changes to zzzz. And so on.

Can someone help me with that?

Thank you

I tried to reproduce here my table with columns A B and C but as I sent the question, I notices the formmating went wrong =(