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

[TABLE="width: 561"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]SKU[/TD]
[TD]Item Name[/TD]
[/TR]
[TR]
[TD]ELF02[/TD]
[TD]Beef Bully Stick 6"[/TD]
[/TR]
[TR]
[TD]ELF02[/TD]
[TD]Small Generic Box[/TD]
[/TR]
[TR]
[TD]ELF02[/TD]
[TD]Box Label Small[/TD]
[/TR]
[TR]
[TD]ELF02[/TD]
[TD]Beef Label[/TD]
[/TR]
[TR]
[TD]ELF03[/TD]
[TD]Beef Bully Stick 12"[/TD]
[/TR]
[TR]
[TD]ELF03[/TD]
[TD]Small Generic Box[/TD]
[/TR]
[TR]
[TD]ELF03[/TD]
[TD]Box Label Small[/TD]
[/TR]
[TR]
[TD]ELF03[/TD]
[TD]Beef Label


[/TD]
[/TR]
</tbody>[/TABLE]
End result that I am seeking

[TABLE="width: 822"]
<colgroup><col span="6"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Beef Bully Stick 6"[/TD]
[TD]Beef Bully Stick 12"[/TD]
[TD]Small Generic Box[/TD]
[TD]Box Label Small[/TD]
[TD]Beef Label[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ELF02[/TD]
[TD="align: center"]X[/TD]
[TD][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD]ELF03[/TD]
[TD][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]X[/TD]
[/TR]
</tbody>[/TABLE]

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