Joining identical items to show as one????
 

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


--
cazajosa
------------------------------------------------------------------------
cazajosa's Profile: http://www.excelforum.com/member.php...o&userid=33649
View this thread: http://www.excelforum.com/showthread...hreadid=534246