Append based on match

[Lucaanto99]

Hi,

I have a set of data that contains information in a given row and I have that data separated in a different stream. I need to append to all rows until there is another data point in that column and then repeat the same. Does anyone have any ideas?

[afv2688]

Hello @Lucaanto99,

It seems that what you are looking for is the append tool but not sure if there is something specific you want to do.

Could you please illustrate it with an example?

Regards

[Lucaanto99]

In the attached, I need to fill the blanks with what is above until I hit a new data point

[afv2688]

Hello @Lucaanto99,

Does this look right to you?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Lucaanto99]

Thanks @avf2688,

Based on your solution, I slightly changed it for my data and ended up with the attached:

[afv2688 · Accepted solution]

Glad it helped you. If you need anything else let me know.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards