Woodward4

Is there a way to "ignore" columns like Room Name that we know are going to be different but want to group similar items anyway and still display those columns that have the differences? For example, I want all 2668 R In doors to be grouped together, but I want to display the different room names for those doors in the column and not have a separate row for each door.