Hi everyone,
I have a spreadsheet similar to this example with a lot of countries and products and I need to get a a list of products with a 2 under the status of page columns alongside the Country this product comes from. I don't need to separate the count of German and English products within a country so for product x in Germany I would just say there's 2 product x pages for Germany and 1 for UK.
I thinking of beginning to do this by filtering out columns by the second row but I cant seem to find a way. Any ideas?
Solved! Go to Solution.
Hi @DavidGorrie
will you please include these sample data in a spreadsheet? Also include, in a spreadsheet and an image, what your desired outcome looks like.
Thanks this was really helpful!