I have edited a cvs/xls (2003 format) file to make sure certain columns are split in two, so I could make two drop down list filtered to each other. At least that was the plan, I have not done this yet. Now it is just some text string, so all the points of my shapefile what the table could have been joined to are filled in. But considering I am gonna create some database trigger, I want it back to the way it was before.
This is what it was originally:
And now it is like this
Now I want to have it back like the original. Written out the same like that.
How do I do this?
Edit: I tried to use the case expression but no matter what this happens:
Edit 2: Even using Case Null has the same effect.