Pls help to write this formula

Question

Column Employee ID have 2 type of data (Number & Text). Number ID (Ex: 20000654) belongs to permanent staff & Text (Outsoure) belongs to Temp. I want to add one more customs column & insert formula to split Perm/Temp. Can someone help me?

Answer 1

If you want to split this table into a table of permanent staff and outsource staff, you could split column on first number, then reference this query twice (one for permanent staff and one for outsource staff), where you filter on null values on the opposite column