Matching two Columns and Concatenating Values

[Quinn1992]

I need to match two columns Customer Number and Company Code, as shown in the image below.


Untitled.png

The data set I'm dealing with is very large and I need an effective way of doing this if possible, I've looked at alot of examples for index and match but I can't understand how to apply this to my problem.

Any help would be welcome.

[alansidman]

Here is a UDF that will do exactly what you are looking for:

[Vikas_Gautam]

Hi,
I have use a udf CONCATALL which I think is best for the situation..
To know more about the formula, try FORMULA AUDITING...
Check the attached file..

[GeneralDisarray]

I'm posting this for .... educational purposes I guess since this is already solved I think.

Please Login or Register  to view this content.