Hi guys, I'm trying to do the below, basically working from column A, and I want to output it to column B without the spaces in the rows. Is this possible? Thanks.
Apples | Apples |
Oranges | Oranges |
Pears | Pears |
Strawberries | |
Strawberries | Cherries |
Cherries | |