Combining cell values

[JP SIngh]

I have a list which has companyname and contracts numbers in column A & B

Example

Company Name Contract Number

AAA 888888
BBB 888088
BBB 888333


What I could like to do is to write a formula or a macro to combine all the
contracts numbers for a company into a single cell

for example

AAA 888888
BBB 888088, 888333

Can this be done?

Thanks

 

[Rajkumar]

Pls try this formulae in column C =A1&" "&B1

Note : " " is for spacing

Rajkuma

 

[JulieD]

Hi

i found this answer from Frank Kabel awhile back and saved it for just such
an occassion -

one way (this requires VBA):
- download Alan Beban's array functions: http://home.pacbell.net/beban
- download the free add-in Morefunc.xll
(http://longre.free.fr/english/)

Now use the following formula:
=MCONCAT(VLOOKUPS(DATE(2004,3,17),A1:B100,2,0),", ")

- correct the formula and adjust for your situation
=MCONCAT(VLOOKUPS(D2,$A$1:$B$100,2),", ")

assuming the date is in column A and the description in column B

and a list of the unique Company Names are in column D starting at row 2
and this formula is entered into column E.

let me know how you go, i had to play around with it for awhile before i
could get it to work.

Cheers
JulieD