Duplicate columns with different filter

mahoneypat thanks for the help

I have just found Referencing... the only issue is this adds a column to a new table not an existing table. It also doesn't like the referencing loop caused by trying to create a column that references a column from the same table.

Essentially, I have both string values and numeric in my column. I need to seperate these out as numeric values column and string column. From there, the string column values are each a composite of 3 seperate numeric values with a delimeter joining them and they will then be split with this delimeter.

EG) seperate values of 2    7    5    6 as well as "2342-234234-234" are in the same column with the - (dash) being a delimeter for spliting later.

I want all these sets of numeric values as seperate columns in the same table, meaning there will need to be four columns as a result, not just one (the numeric values and then the three numeric values that result from the delimeter split).

So, I need to have duplicate columns in the same table (that act like reference columns) so that I can first filter out the one column with the delimeter values (which will then be split) and the other (perhaps the origional column) to filter without the delimeter values.

I'm not sure i'm going abou tthis the right way, but i would prefer to have the process done in the "Transform"/Power Query side of things. But ultimately I just want the values to show up in the "Fields" data source area as seperate values I can drag and drop as seperate values/columns.

I hope this made sense.