I have an excel worksheet where I have the following colum headings City, Zip, Mfg, Code, Model and Serial Number. I am concatenating the data from Code, Model and Serial # into column H. What I need is a script or something to go through the worksheet and find all records that have the same city and zip and combine all the respective data in column H for those records in the same cell on a Results worksheet. For example:
Columbus, 43215, ...code model serial 1
Columbus, 43215, ...code model serial 2
Columbus, 43215, ...code model serial 3
Columbus, 43215, code model serial 1
code model serial 2
code model serial 3
Also need it to move all the unique records from the source page to the results page.