Remove data rows between 2 subheader

[Zac_Soh (Zac)]

I have a table from pivot table with 2 groups e.g

Header1     |header2|header3|
group1 title|       |       |
data1       |data2  |data3  | 
group2 title|       |       |
data4       |data5  |data6  |

How do i do a while loop or select to delete any data between group1 title(inclusive) and group2 title so the result would look like:

Header1     |header2|header3|
group2 title|       |       |
data4       |data5  |data6  |

The number of rows varies that's why i couldn't hard-code something like A2:C3

[aksh1yadav (AKSHAY YADAV)]

Hey @Zac_Soh

@Zac_Soh

How do i do a while loop or select to delete any data between group1 title(inclusive) and group2 title so the result would look like

Please find below sample for your assistance using While Loop
Excel Column Range Filter.xaml (12.5 KB)

I hope it will help you for sure

Regards…!!
Aksh