Hi everyone,

I am looking for help in formula or VBA for situation:

columnA columnB

1 ______ a

2 ______ s

2 ______ d

2______ f

3 ______ g

1______ h

3 ______ j

3______ k

I need to concatenate values of column B by unique value of column A. Final product will look like:

columnC columnD

1 ______ a,h

2 ______ s,d,f

3 ______ g,j,k

Thank you very much for any help!!

I am looking for help in formula or VBA for situation:

columnA columnB

1 ______ a

2 ______ s

2 ______ d

2______ f

3 ______ g

1______ h

3 ______ j

3______ k

I need to concatenate values of column B by unique value of column A. Final product will look like:

columnC columnD

1 ______ a,h

2 ______ s,d,f

3 ______ g,j,k

Thank you very much for any help!!

Last edited: