P
pgarcia
I have the following, how can I concatenat the cells?
Row A has dup but row B does not. I need a formula that will look up row A
and concatenat row B, but if row B was alread concatenated, then concatenat
the next cell. e.g. ABD = AIR EXPORT / Domestic, e.g. ACS = AIR EXPORT /
DOMESTIC / Ocean Export etc.
ABD AIR EXPORT
ABD Domestic
ABO AIR EXPORT
ABO Domestic
ACC AIR EXPORT
ACC DOMESTIC
ACF IMPORT BREAKBULK
ACL CMIN
ACL Logistics
ACS AIR EXPORT
ACS DOMESTIC
ACS Ocean Export
ADC AIR EXPORT
ADC Domestic
Row A has dup but row B does not. I need a formula that will look up row A
and concatenat row B, but if row B was alread concatenated, then concatenat
the next cell. e.g. ABD = AIR EXPORT / Domestic, e.g. ACS = AIR EXPORT /
DOMESTIC / Ocean Export etc.
ABD AIR EXPORT
ABD Domestic
ABO AIR EXPORT
ABO Domestic
ACC AIR EXPORT
ACC DOMESTIC
ACF IMPORT BREAKBULK
ACL CMIN
ACL Logistics
ACS AIR EXPORT
ACS DOMESTIC
ACS Ocean Export
ADC AIR EXPORT
ADC Domestic