Filtering columns by second row of data

[DavidGorrie]

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?

[seven]

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.

[echuong1 · Accepted solution]

I suggest concatenating the two header lines together. From there, you can use a dynamic select to identify only the fields with "page" in it, and then filter from there. See attached for an example.

Hope this helps!

[DavidGorrie]

Thanks this was really helpful!