Is it possible to list doors of the same type but different zones as one column ? " lets say the ID is D-1 and its the flagged field , but its there are 10 of it in different zones , I want it to be listed as one column "D-1" but in location field it says " Room 12, Room 15, Room ..etc " instead of having 10 different columns of D-1 where each one is in the correct zone but quantity is 1 .
What I am doing now is to put the location field as custom and type it manually.
Thanks.