Concatenate Unique advanced filter results
Hi out there
I have 2 columns that have been advanced filtered to provide unique records
for shipment destinations / each carrier used for that destination.
B = destination
C = carrier
FRA AA
FRA BA
JFK AA
JFK 5X
SFO AA.... SO ON
I would like to further filter my results so that column C = Ea unique
destination and column D = concatenate result of each carrier used (seperated
by / or , or -)
if anyone can shine some light on how this maybe accomplished, Greate
Appreciated.
Thanks, Steven
|