filter the data based on the Specific word

Navyasree123

Hi All,

I have a query today, can anyone please help me out

I have attached the input and output

To split the data from Earning to earning in the separate sheets

Thanks in advance

Agency data.xlsx

Agency output.xlsx

Raj

@Navyasree123  use multi row formula to group them and this will work for you,
hope this helps.
mark done if solved.