Filter data table with regex for value

Hi,

What I want to do is very simple - here is a screenshot for illustration:

image

As the print shows, I have one column with two kinds of data which I want to split into two columns with each type of data from the first column.

I have tried multiple solutions, but I keep getting one of the following scenarios:

Either I get the two columns of data like so:

Or like this:

image

This is really frustrating - I really hope you guys can help.