Is it possible to do this?

[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]

You have a response at your other post.

Please don't multipost.