Concatenate same number in a data

[skr971]

Hi All,


i have a little bit problem, i need help for below function :

i have a raw data, which are duplicate customer ids and i need concatenate amount which are customer ids are same

For ex :

Raw Data	Customer ID	Amount
	1	2
	2	3
	3	4
	4	5
	1	3
Ans	Customer ID	Amount
	1	2 , 3
	2	3
	3	4
	4	5

<colgroup><col><col><col></colgroup><tbody>
</tbody>

thanks in advance

regards
SKR

 

[Arithos]

Hi All,


i have a little bit problem, i need help for below function :

i have a raw data, which are duplicate customer ids and i need concatenate amount which are customer ids are same

For ex :

Raw Data	Customer ID	Amount
	1	2
	2	3
	3	4
	4	5
	1	3
Ans	Customer ID	Amount
	1	2 , 3
	2	3
	3	4
	4	5

<tbody>
</tbody>

thanks in advance

regards
SKR

I do not know of a simple function to do this, but if a macro is a possibility let me know

 

[Andrew Poulsom]

That would require VBA. Here's one possibility:

http://www.mrexcel.com/forum/excel-questions/205913-concatif.html

 

[Arithos]

Indeed it would require VBA, however that function should do it for him, may need some minor modifications just adding some " ," or something. Nice link.