Generate rows based to fill in order numbers

[jkv0019]

Hello,

I am trying to carry the customer ID string down for each row of order IDs. There is abundant help on how to do this with dates and numbers with the generate rows tool, but how about with text?

I've had limited success when using the multi-row tool to achieve this, but am struggling for when there are varying number of rows that need to be filled in.

[Qiu]

@jkv0019 
Multi-Row Formula tool is very powerful in these cases.

We can see your data is actually grouped for order ID, so we can do like this.