Concatenate Macro

[behnm]

Everyday I receive lists of information that contain the following column headers: Section, Serial #, Part #, and Date. I want to create a macro that will concatenate the values in the serial # column according to values in the section column (ie. All serial number values that are section A will be concatenated with a comma between the serial number values and the same will be done with serial numbers of section b, c, and so on). When concatenating, the serial number values need to be separated by a comma. The input information and the amount of entries change from day to day, but the column headings are the same. Any thoughts?

 

[deven_deesha]

If I understood the question correctly. you have to concatenate three columns with "," in between.

=CONCATENATE(A4,",",B4,",",C4)

Try this one. Hope this helps.