Can this be done?

[Mike Mike]

Is it possible to move column B fields to the row with matching content in A

From this:

A B
bananas yellow
oranges candy
pigs bananas
cows blue
candy
blue
red
yellow

To this:

A B
bananas bananas
oranges
pigs
cows
candy candy
blue blue
red
yellow yellow


Regards
Mike

 

[Dave Peterson]

I'd insert a new column B (shifting column B to column C), then use a formula
like this in B1:

=if(isnumber(match(a1,c:c,0)),a1,na())
and drag down as far as you want.

Then Select column B
edit|copy
Edit|paste special|values

then with column B still selected
edit|Replace
what: #n/a
with: (leave blank)
replace all

and delete column C (which holds the data in the old order).

Be aware that any value in column B that doesn't appear in column A will be lost
using this technique.