Excel 2010
I have 3 lists of user names:
List 1 - Active Employees - 1200 items
List 2 - Active Email Addresses - 2200 items
List 3 - Active AD accounts - 4400 items
I am trying to align the columns to match like data.
EX:
current
A B C
1 a b b
2 b c d
3 c f e
4 d j f
5 e k k
desired
A B C
1 a * *
2 b b b
3 c c *
4 d * d
5 e * e
6 * f f
7 * j *
8 * k k
So far all of my attempts have failed, as there is not always a match; a name may appear in only one column.
My methodology may be flawed; if anyone has any suggestions, it would be very appreciated.
I have uploaded a small sample of the data.
Bookmarks