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.
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. Read More