multi row formula

[xariet]

Hi!

I am trying to combine values from two rows into one for each corresponding ID. My example file contains first table as my data now and second table my desired output. I am guessing I need to use multirow formular here, just can't figure it out .

Thank you for your help!

[ntakeda · Accepted solution]

1.since the ID contains null values, use a multi-row formula to fill the nulls with the value from the row above.

2. concatenate the data.

I am attaching a workflow file, so please refer to it.