Match & Sort

[lucs]

Hi everyone

I'm looking for some advice. I have the following columns that I would like excel to match based on the 2nd and 4th columns, and then sort:

1 car 5 tree
7 bread 2 car
3 tree 8 bread

So, ultimately, what I'm hoping to get is (in no particular order):
1 car 2 car
7 bread 8 bread
3 tree 5 tree

I'm sure there must be a way to do this, but I'm not really sure how to do so. Any help would be REALLY useful! Thank you!!!

[zbor]

What if there are non-matching words?

Book1.xls

[lucs]

Zbor, thank you SO much! This is awesome!