DC DATA CENTER
IT INFO TECHNOLOGY
PM PROJECT MANAGEMENT
¿ME MEDICAL EQUIPMENT
So basically the Org column that has colons separating contains the code in the 2nd table at the end. As an example the US:06:AV actually points to AV for AUDIOVISUAL in the 2nd table.
Thus I'm trying to create a view that gives WBS1, WBS2 and then a description of that code tied together in a relationship. This would be a lot easier if there was a column that only had the AV code but in this case I'm having to parse it out and then use it as such in a relationship. Then I have to take it a step further and if there are multiple disciplines show in a comma separated way.
How do I go about creating a view that as my example would show as the following?
9414 ACOUSTICS, GENERAL
9415 ACOUSTICS, REIMBURSABLE
9455 INFO TECHNOLOGY
Again, please note attached Excel file with its 3 sheets as to what I'm trying to do.