to spread data in a column in order to match it wit other colums

good morning
is there a way to spread data in a column in order to match with data in another column?

example:

apple|3|orange
orange|2|banana
lemon|6|cat
banana|9|null
dog|7|null
cat|1|null
fish|6|null


apple|3|null
orange|2|orange
lemon|6|null
banana|9|banana
dog|7|null
cat|1|cat
fish|6|null


many thanks!
cristiano

Let me know if this is what you had in mind. Changes highlighted in green.

Just what I was looking for
thank you very much, really precious!