matching data

[patwary8]

I have my data in column 1 and 2 like this

M Y
R U
D R
Y K
K D
U M

but i want them to be arranged like this

M M
R R
D D
Y Y
K K
U U

Can anyone help me please.

[hokeyplyr48]

i apologize i misread your data.

please disregard post

[patwary8]

I want to match/compare my data in two different column and write them side by side.

Can anyone help?

[NBVC]

What do you mean by compare?

You want to see if the letter in column 1 exists somewhere in Column 2 then write that letter?

[patwary8]

Yes, i want to see if a letter in column 1 exists somewhere in Column 2, then write that letter right beside it (in column 2). Can you help?

[NBVC]

=IF(ISNUMBER(MATCH(A1,B:B,0)),A1,"")

Where A1 is value to match in column B.