maximus1974
asked on
Need help separating values from a column and creating a new record
I have records where:
COMPANY NAME PART NUMBER MFG CODE CAPABILITY CODE
Acme LLC A123 1234A BC Repair OVH
I want to create a new record for each value in capability code and look like this::
COMPANY NAME PART NUMBER MFG CODE CAPABILITY CODE
Acme LLC A123 1234A BC
Acme LLC A123 1234A Repair
Acme LLC A123 1234A OVH
Book1.xlsx
COMPANY NAME PART NUMBER MFG CODE CAPABILITY CODE
Acme LLC A123 1234A BC Repair OVH
I want to create a new record for each value in capability code and look like this::
COMPANY NAME PART NUMBER MFG CODE CAPABILITY CODE
Acme LLC A123 1234A BC
Acme LLC A123 1234A Repair
Acme LLC A123 1234A OVH
Book1.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mike, The most capability codes you will see in the capability_code column is BC REPAIR OVH. Does this help you?
Yes, it is very helpful. Your answer probably could be stated like:
Min: 1 capability code
Max: 3 capability codes
When more than one, the capability codes are separated with a single blank space and there are no leading or trailing spaces.
If anything different than what has been stated above, we will be able to deal with it later. But for now, we proceed with these assumptions.
Mike
Min: 1 capability code
Max: 3 capability codes
When more than one, the capability codes are separated with a single blank space and there are no leading or trailing spaces.
If anything different than what has been stated above, we will be able to deal with it later. But for now, we proceed with these assumptions.
Mike
ID: 42087361 can handle up to 100!
did you check it?
did you check it?
Open in new window