Hey there I am having an issue where I cant find a formula to do the following:

I have four columns two of which contain identical text (which is sorted in a different order). Next to each text cell is a corresponding number in the next column. So A1 contains text and B2 contains a corresponding number. Column C2 contains text and D2 contains a different corresponding number.

What I want to do is to find the matching text from the two text columns and merge (the identical text)and move the corresponding number from the duplicate cell to the same row so I end up with:

A1 (text) B2 (number) D2 (number) or text number number

Another way to explain it is:

I have two lists of matching text but with different numbers in the cells next to each column of text. I want to move the matching text and the number next to it.

Would be very grateful for some help cheers