I have multiple columns and need to concatenate the unique records from each into a single cell in each row. I am pretty sure I need to loop through the columns in each row until I reach an empty cell in the right of the range, but the problem I am running in to is that sometimes the records in non-adjacent cells match and I only want the value to show once. I have attached a sample file to show what I mean. I want to concatenate the unique class values into a single list in the far right column. Any help would be appreciated.