Thanks for checking. This is not a duplicate, although the idea is similar.
What's different about this question is i want to combine values in each of 5 columns, when values in each of four columns are identical.
The other question only checked values in one column, then combined values in another single column.
Like the other question, however, I'd like to not have to type in each value that I want to match. I just want it to find matches itself. There are so many rows that having to redo the forumla for each value would mean I'm not saving much time.
Thanks. Here's a sample from the file. The actual file has 245,343 rows. That's why I don't want to have to enter in each individual group of values to match.
that's fine. sleep well.
Sure. The end result I want is for rows 2 to 5 to be combined so that I have one row for "Costa Rica, Costa Rica, Costa Rica, Alajuela."
The same for rows 7 to 11.
The same for rows 12 and 13.
The same for rows 13 to 18.
I've got almost endless rows like this, and I hope Excel will be able to combine those rows that are duplicates in columns A to D.
Thanks. I'll check it out. I have been told I can do pivot tables on a Mac, but I've never actually done one.