I have two columns in my spreadsheet.
For column C, I set a formula as something like randomly pick a person, that's mean the value under Column C [Result] is changeable. Then, I would like to append the displayed name in column D.
For example. C2 generated Carry, then Result List show 'Carry' on D2.
Then, C2 generated Peter, then Result List show 'Peter' on D3.
Then, C2 generated Lily, then Result List show 'Lily' on D4.
Finally, Column D show Carry (on D2) and Peter (on D3) and Lily (on D4)
Is this doable for google sheet? which formula should I use?