Hello to all....I have a task to join several identical items as one. I have tried the Pivot Table but it just gives me qtys. There is hundres (thousands) of entries and to be deleting the extra ones takes a long time. Is there a formula to just show one row of each? See Below. Thanks.

example:
4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral
4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral
4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral
4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral
4/1/2006 200298230 H0789643202 2 Rework 98415 Liners
4/1/2006 200298230 H0789643202 2 Rework 98415 Liners
4/1/2006 200298230 H0789643202 2 Rework 98415 Liners
4/1/2006 200298230 H0789643202 2 Rework 98415 Liners
4/1/2006 200298230 H0789643202 2 Rework 98415 Liners