Separating columns - needing them filtered without filtering the other out

[Caylee]

I need to separate a "Job title" column into two then filter the first to be only Project Managers and filter the second to be only Senior Project Managers. When I attempt this, it will not work the way I am hoping - 

1. I am not able to add both filters within the filters tab because once added it removes the other option from the other column.

2. If I add both titles to each columns filters then it splits the titles into two rows (based on the project in column 1) and has the same title in each column based on the employee name.

[Anonymous]

Hi @Caylee ,

Regarding your question, is there a separator between the two job titles in 'Job title'? If there is, you can use the 'Split column' function in Power Query to split the 'Job title' into two columns. If I have misunderstood, can you provide some simple data?

Split columns by delimiter - Power Query | Microsoft Learn

Best Regards