Please help if you know how to copy data from previous cell. For example, I
only have column A and column B. But I would like to have the person name on
every row. Expected result is in column C. See example below...

Col A Col B Col C (Expected Result)
John apple John
orange John
kiwi John
Mary grape Mary
banana Mary
apple Mary