Filtering out field data in separate from a particular field

Hi Team,
I want to retrieve a particular data in a field by using if-else condition statement. So how can I do that?
PFB for your reference
Lets say here, I want to retrieve below field data in separate field by using calculated field.
Field Data