I'm interested in finding out the best method to program a string of room numbers so they can report cost center data.
IN [Room] | Cost Center Read Out |
201-02','201-04','201-16','201-18','201-24','201-26','201-28','201-36','RM201.1','RM201.2','RM201.3' | LRL MedChem-100A93A |
201-08','201-10','201-12','201-14','201-20','201-22','201-32','201-34' | RNA Therapeutics-1000081 |
301-02'',301-08','301-12','301-14','301-16','301-22','301-26','301-28','301-34','301-36', | LRL MedChem-100A93A |
301-24 | Structural Computational Sciences-100AF94 |
104-02','104-06','104-10','104-12','104-14','104-16','104-22,'104-24','104-26','104-28','104-34','104-36','RM104.1,'RM104.2',RM1.3' | Protein Discover Research-100A625 |
I think a summarize is all you need. Group it by the Cost center and concatenate the Space Number Table Number column.
Assuming you are wanting the single quote around each item, you just need to setup the concatenate options to add them in.
Ok, Let me try your recommendation.