[Google sheet] appending the data to a column

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?
Screenshot 2023-10-17 at 12.08.11 AM.png

0 0 326
0 REPLIES 0
Top Labels in this Space