I have a table where there are pack type/offer columns.
There are few row items in two columns which are common.
How can I take only the items that are common.
I want to take only those columns that are highlighted.
My first option with calculated column will help you there .
You can put flag for that visual where you want this effect and select “Y”
This will do the trick.
My sincere apologies, i missed it up. Like everything is in the same column only as offers only the manufacturer differs. IN this case how can i do this. In the image above just think of it like this,
Manufacturer is a column and offer is another column
this is the raw data. I want only those common offers at a visual level