Hi, I have an excel file exported from my database with a ton of data for different items. Each item has a date associated with it, and then each item has categories where an X may or may not be entered. The task of the macro would be to combine the same items with like dates as well as their categories with X's in them. This could be output in a seperate file, or the repeating item & dates can be deleted as the macro progresses through the list. Does anyone know how to go about doing this?