Remove data rows between 2 subheader

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

Hey @Zac_Soh

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

I hope it will help you for sure :slight_smile:

Regards…!!
Aksh

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.