core.noscript.text
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!
Solved! Go to 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.
