Forum Discussion
Insert Blank Row between Filters using VSTACK
I have a working VSTACK formula with 2 filters. I would like to insert a blank row or even a copied header row between the two filter in order to separate the data visually on the combined sheet.
Here is the current formula:
=VSTACK(FILTER('AV POWER Overall'!A3:K200,'AV POWER Overall'!K3:K200='TA00-A101'!N2),FILTER('LX POWER Overall'!A3:K200,'LX POWER Overall'!K3:K200='TA00-A101'!N2))
Screenshot is the combined sheet.
As variant
=VSTACK( headers, FILTER('AV POWER Overall'!A3:K200,'AV POWER Overall'!K3:K200='TA00-A101'!N2), IF( COLUMN(headers), "" ), FILTER('LX POWER Overall'!A3:K200,'LX POWER Overall'!K3:K200='TA00-A101'!N2) )where the headers is the reference on related range.
As variant
=VSTACK( headers, FILTER('AV POWER Overall'!A3:K200,'AV POWER Overall'!K3:K200='TA00-A101'!N2), IF( COLUMN(headers), "" ), FILTER('LX POWER Overall'!A3:K200,'LX POWER Overall'!K3:K200='TA00-A101'!N2) )where the headers is the reference on related range.
- This is perfect! Thank you.
How difficult would it be to apply a fill to that row as well?You are welcome. Instead of
IF( COLUMN(headers), "" ),you may use
IF( COLUMN(headers), REPT("|",25) ),or like
