Column match on same row

[kway2004]

I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku.

Beginning data table

SKU	Item Name
ELF02	Beef Bully Stick 6"
ELF02	Small Generic Box
ELF02	Box Label Small
ELF02	Beef Label
ELF03	Beef Bully Stick 12"
ELF03	Small Generic Box
ELF03	Box Label Small
ELF03	Beef Label

<colgroup><col><col></colgroup><tbody>
</tbody>

End result that I am seeking

	Beef Bully Stick 6"	Beef Bully Stick 12"	Small Generic Box	Box Label Small	Beef Label
ELF02	X		X	X	X
ELF03		X	X	X	X

<colgroup><col span="6"></colgroup><tbody>
</tbody>

Of course the beginning table has about 1200 lines to it. I have tried If(And(match which gives me "X" in cell that should not have them because of the condition is satisfied once it finds a match in both columns. I need the column match to be for the same row.

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	SKU	Item Name					Beef Bully Stick 6"	Beef Bully Stick 12"	Small Generic Box	Box Label Small	Beef Label
2	ELF02	Beef Bully Stick 6"
3	ELF02	Small Generic Box				ELF02	X		X	X	X
4	ELF02	Box Label Small				ELF03		X	X	X	X
5	ELF02	Beef Label
6	ELF03	Beef Bully Stick 12"
7	ELF03	Small Generic Box
8	ELF03	Box Label Small
9	ELF03	Beef Label
Summary

Cell Formulas
Range	Formula
G3	=IF(ISNUMBER(MATCH($F3&"|"&G$1,INDEX($A$2:$A$9&"|"&$B$2:$B$9,0),0)),"X","")

 

[kway2004]

Your formula works perfectly. Thank you

 

[Fluff]

You're welcome & thanks for the feedback