If cell contains value, bring back adjacent columns

datamark · April 5, 2018, 1:46pm

First time poster here, as I’ve always used the forums to find answers. However, I’m stuck on this one…

I have about 200 columns in my spreadsheet. As an example it has:

If there is an option with the value “optional” I’d like to bring back the column values for “short description” and “price” and ignore anything that isn’t “optional”.

Is this possible? Any help would be very appreciated as I can’t find any similar posts on the forum.

Mark

Jeany · April 9, 2018, 10:08am

Hi Mark,

Welcome! One possibility would be to use a row filter to filter for “optional” in the column option. Subsequently you can use a column filter to filter the columns you want to display in the end.

Hope that helps,
Jeany

system · June 2, 2023, 9:45pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.