I have 2 columns of data. Column A with a list of items (say computer SN) and Column B with a list of Sub items (accessories). An Item (column A) can have multiple sub items (column B) and vice versa.
There are about 250 entries.
I want to create a table with unique entries.
SubItem1 SubItem2 Subitem3
Item1 YES No Yes
Item2 No Yes Yes
Item3 Yes Yes No
Not sure how to use vlookup or Index/Match.
Solved by C. C. in 37 mins