In a Previous Post I had a formula below which Scanned Columns C:Q in Row 3 Which is the Header Row and Showed the 2 column with the Headers Country and Population
Formula Entered in A2 =FILTER($C$3:$Q$100,($C$2:$Q$2 ="country")+($C$2:$Q$2="population"))
However as I don't know how far down the Rows will appear if Data ends at Row 80 it shows 0's in the Array formula
Array highlights the 0's
I changed to below to change 0's to "" but still shows in the array
=FILTER($C$3:$Q$100,($C$2:$Q$2 ="country")+($C$2:$Q$2="population")) & ""
Array highlights the blanks
I know in normal filters you can have this to avoid Blanks, but not sure how to add to formula above
=FILTER($B$1:$J$1, $B$1:$J$1<>"")
Formula Entered in A2 =FILTER($C$3:$Q$100,($C$2:$Q$2 ="country")+($C$2:$Q$2="population"))
However as I don't know how far down the Rows will appear if Data ends at Row 80 it shows 0's in the Array formula
Array highlights the 0's
I changed to below to change 0's to "" but still shows in the array
=FILTER($C$3:$Q$100,($C$2:$Q$2 ="country")+($C$2:$Q$2="population")) & ""
Array highlights the blanks
I know in normal filters you can have this to avoid Blanks, but not sure how to add to formula above
=FILTER($B$1:$J$1, $B$1:$J$1<>"")