Concatenate Unique advanced filter results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top