Hello Everyone,

I'm trying to figure out how to produce an output file using SUPRTOOL that
takes all duplicate input records and adds the unique records on a single
line.

Example:

INPUT

Shipdoc #       Tracking #

12345           1Z12345
12345           1Z123ZZ
12345           1Z12300
12345           1Z12399
12346           1Z00000
12346           1Z88888
12347           1Z99999

OUTPUT

SHIPDOC #       TRACKING #1     TRACKING #2     TRACKING #3     TRACKING #4
12345           1Z12345 1Z123ZZ 1Z12300 1Z12399
12346           1Z00000 1Z88888
12347           1Z99999

Any help on this would be greatly appreciated!

Regards,

Greg Tompkins
Salomon North America
voice/fax +1 (503) 548-7070
[log in to unmask]