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: