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

Concatenate Unique advanced filter results
 

I'm not really sure what you're trying to accomplish but the concatenate
function works like this:

=CONCATENATE(A1)," / ",(B1) if you want to concatenate the values in A1 and
B1 and have a / separate them.

"SteveT" wrote:

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