Hi Anonymous 

Please try this, create a new column

IsFcs = IF(CONTAINSSTRING('Table'[Employee Name],"Fcs"),1,0)

Since there is no relationship between Club Employee and Fcs Employee, you need to put them into separate tables

table1 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=1),"Fcs",[Employee Name])

table2 = SELECTCOLUMNS(FILTER('Table','Table'[IsFcs]=0),"Club Employee",[Employee Name])

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.