Using the IN function to function for a string of room numbers and map to a cost center

[lynettejackson]

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

[SPetrie]

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.

[lynettejackson]

Ok,  Let me try your recommendation.