Getting values from column data

[Charcho]

Hello,

I want to extract all the values from column B belonging to the same 'Fruits&Other' (column A).

I use Find and Replace but I am getting only one line and not all the fruits from column A.

table:

Thank you

[PhilipMannering · Accepted solution]

You want to just Filter to Fruits&Other? Can you share a table/image of your expected output?

[MilindG · Accepted solution]

Do you have the expected output? Not sure if either of these solution works for you

[Charcho]

Thank you for the replies. I didn't explain well... I am using Find and Replace tool in a dataset and my situation is that I get only one line as result.

My expectation is the solution by @MilindG but using this tool.

The complete solution would be:

Thanks again

[PhilipMannering · Accepted solution]

You only get one result because the table you're doing the "lookup" on only has one row. If you're looking to filter to "Fruits&Other", the Join Tool is the one to use. Find and Replace output will have the same number of records as the table passed into the F anchor.

[Charcho]

That's correct @PhilipMannering with the Union tool I get the expected. Thank you for the contribution and the hint about the F anchor.