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
<colgroup><col><col></colgroup><tbody>
</tbody>End result that I am seeking
<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.
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>
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.