The previous script didn't really do anything when I . . . perhaps I'm missing something.

I think I can easily write a script to delete duplicate rows of data. The problem is that ALL the data in the row, other than the region data, is the same. I'd like to combine the region data in that case so that they are in one cell and separated by a comma.

I think I can also write script to combine data into a single cell being separated by a comma, however, I'm running into problems because the regions column has data in both columns to the left and right of it.

If anyone could provide any insight that would be appreciated. Thanks!