PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH
"NICK" wrote:
I need to produce a list by sevice owner(column b) that will print all the
rooms(column a) that fall under each service. please see below
i.e. Service
EMS 10002A,1002B,10010A.......
Psychiatry 10002,10009, 10010, 10014........
ROOM SERVICE OWNER SECT
10002 PSYCHIATRY NURSING STATION
10002A EMS TOILET
10002B EMS TOILET
10009 PSYCHIATRY DINING RM
10010 PSYCHIATRY BREAK RM
10010A EMS TOILET
10014 PSYCHIATRY GROUP RM
10101 PSYCHIATRY LOCKER RM
10020 PSYCHIATRY GROUP RM
10020A RECREATION STORAGE
10100 PSYCHIATRY MUSIC RM
10101 PSYCHIATRY LOCKER RM
10102 PSYCHIATRY CONFERENCE RM
10103 PSYCHIATRY GROUP RM
10104 PRIMARY CARE/NURISNG OFFICE
10105 PSYCHIATRY TESTING ROOM
10106 REHAB RESTORATIVE CARE SERVICE STORAGE
10107 ENGINEER CLOSET TELEPHONE
10108 EMS STAIRS
--
Thanks, Nick
|