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

Column A	Column B	Column C
100001	35
100001	64
100001	45
100002	64
100002	72
100002	74
100002	68
100002	59

<tbody>
</tbody>

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:

1	Column A	Column B	Column C
2	100001	35	35
3	100001	64	35, 64
4	100001	45	35, 64, 45
5	100002	64	64
6	100002	72	64, 72
7	100002	74	64, 72, 74
8	100002	68	64, 72, 74, 68
9	100002	59	64, 72, 74, 68, 59

<tbody>
</tbody>

 

[kac1125]

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