Value in column B corresponding to column A listed in column c separated by a comma

[kac1125]

Looking to list out all values for Column B that correspond to column A listed out in Column C at change in value of column A separated by a comma
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]100001[/TD]
[TD]35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001[/TD]
[TD]64[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100002[/TD]
[TD]64[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100002[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100002[/TD]
[TD]74[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100002[/TD]
[TD]68[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100002[/TD]
[TD]59[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So I would need For C3 i would need it to read 35,64,45 and C8 to read 64,72,74,68,59

Please let me know if you have any suggestions

 

[william_man]

=IF(A1<>A2,B2,C1&", "&B2)

This formula entered in cell C2 will give an output like this:

[TABLE="width: 361"]
<tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Column A[/TD]
[TD="align: center"]Column B[/TD]
[TD="align: center"]Column C[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]100001[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]35[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]100001[/TD]
[TD="align: center"]64[/TD]
[TD="align: center"]35, 64[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]100001[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]35, 64, 45[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]100002[/TD]
[TD="align: center"]64[/TD]
[TD="align: center"]64[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]100002[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]64, 72[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]100002[/TD]
[TD="align: center"]74[/TD]
[TD="align: center"]64, 72, 74[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]100002[/TD]
[TD="align: center"]68[/TD]
[TD="align: center"]64, 72, 74, 68[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]100002[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]64, 72, 74, 68, 59[/TD]
[/TR]
</tbody>[/TABLE]

 

[kac1125]

Thank you so much! This is exactly what I was looking for!