Filtering of text column in Pivot Table

[MarcinKr]

Hello,
I have a Pivot Table where I want to filter data by one column which contains the codes separated by space.
Example:

Column 1, Column 2, Column 3

1, 2, “A B C”

2, 5, “B C D”

3, 8, “C D E”

All of this data is located in the Pivot Table and for example I want to get all rows, where “Column 3” contains code “B”.
How can I do that?

Thank you!

[erAck]

Under Data → More Filters → Standard Filter… with Field name for Column 3 select Condition Contains and Value B.

[MarcinKr]

It was easier than I thought. Thank you!