Hi guys,

Thank you in advance for your help,

I have a table that has 10 rows and 20 columns. Certain cells have an "X" while other cells are blank.

I would like to first filter the row, say row 1, which has "X" in column 3, 4 and 10. I would like to hide all blank columns.

After which I would move on and filter on row 2, which has "X" in column 6, 12, 19. I would like to hide all blank columns.

I would perform this action for all ten rows.

The purpose of this is to go through each row, and only show the columns that have a "X" based on the row selected.

Any ideas on how I would get started.

Thank you,