This is the first time I send the request to Office KB for the help in Excel.
My problem is to find out one formula which can figure out the result which
I want. There are two sets of data. The first set data is A, B, C, D, E, F,
G and H. The second set data is A, A, G, G, G, G, and H.


The result which I want is when the first data is exist in the second data,
the data will automatic appear in one cell.

For example, because there are 3 A in second set of data, therefore, only one
A appear in first cell. The second cell will have G and the third cell will
have H. I need an Excel formula to have this result!

Many thanks,
Wilchong.