Sort and Match

Happy New Year!!
Here is my Problem,
I need to sort and match two columns or lists of numbers, both list have duplicated numbers. I would like a blank cell, or the dulicated number to show in the column where there is not a duplicate. Sample below.

Before
Column 1 Column 2
1 1
2 1
2 2
3 3
4 4
5 5
6 6
6 7




After
Column 1 Column 2
1 1
1
2 2
2
3 3
4 4
5 5
6 6
6
7

For clarity, I put the final output in columns F&G. If you want the output in the same columns you started with, then change the second half of this code.

Please Login or Register  to view this content.

Is there any way to do this without a Macro? I have never worked with them before and I have no idea what I'm doing there. I have the same problem as the initial post, though I have data in two spreadsheets that I am trying to merge so I would have to expand the selection for each.