Filter specific value of the row that has multiple values

[LukaszXYZ]

Hello,

I have values that are duplicated in different rows, example: 1 recruiter name appears in few rows with another recruiter name.

I'd like to have a filter by a specific name (which will show all values linked with the recruiter), so we don't need to select it multiple times - the problem is that I can't split those columns, because there are only spaces between the names of the recruiters.

Do you have any idea how to solve it? 

Thank you in advance!

[JamesRobson]

Hi,

 Not sure if I've got it right but sounds like you need a Text.Contains so you can get every line with that name on it?

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Primary Recruiters", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.Contains([Primary Recruiters], Filter)) 

**Filter comes from the below query so users can type in any name they wish to search for but you can hard code "Dave Jones" if you prefer**
in
#"Filtered Rows"

let
Source = Excel.CurrentWorkbook(){[Name="Filter"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Filter", type text}}),
Filter = #"Changed Type"{0}[Filter]
in
Filter

Let me know if thats not quite right