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

[Raj · Accepted solution]

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

[Raj]

@Navyasree123 
find the workflow attached
mark done if solved.