I'm working on a door and window schedule for a residential development. We tag doors and windows by giving each item a unique name using the element ID attribute (D01, D02 and so on in case of doors) and then in the door schedule we specify door types: Type A, Type B, etc. and for each type we list the doors that correspond for each type, Type A: D01, D05, D07 - Type B: D02, D03, D08 as well as the quantity, which helps to give the total number of doors and location for each type. See attachment.
What I haven't been able to do do is to get the door names (D01, D02) to be listed in ONE CELL for each type. Is this possible?