How to write a formula to simplify the work?
The following is the example data:
TA-151700001.06
SER
TA-151700001.07
SER
TA-151700001.08
MP
SER
TA-151700002.06
SER
TA-151700002.08
MP
SER
TA-151700001.01.01
SER
TA-151700001.02.01
MP
SER
And this is the result I need:
TA-151700001.06 SER
TA-151700001.07 SER
TA-151700001.08 MP
TA-151700001.08 SER
TA-151700002.06 SER
TA-151700002.08 MP
TA-151700002.08 SER
TA-151700001.01.01 SER
TA-151700001.02.01 MP
TA-151700001.02.01 SER
What I need is, the data below TA-15170000* which is "MP" OR "SER" or both should be like the above.
Please help.
|