I am trying to generate a seperate filtered table using Index Match in Excel. The idea is to allow users to filter using two dependent dropdown lists. I have 10 columns in total, but the dropdown lists is just using two columns to filter dependently.

So in the new table, the user would be able to see the filtered data. I am using Index Match to generate this new table.

=IFERROR(INDEX($A2:$K2,MATCH(1,($C2:$C$12=$T$2)*($D2:$D$12=$T$3),0),COLUMNS($A$19:A19)),"")

The generated table gives blank cells in between. How can I have the lists consolidate the data with no blanks in between rows?

Trying to generate a new filtered table without blanks in between rows.

CodePudding user response：

if you are using office 365 or above, you can use filter formula for the index/match initial result to get rid of the blank.

=filter(A:B,A:A＜＞””)