For each change in row select range

Hi Guys,

I have a short question. I’ve got a mega excel file containg over 100 names.all the rows are grouped together and contain subtotals. What i would like to achieve is create an excel file containing all the rows per group (lets say row 2-40 contain info for group 1 and row 41-80 the next group (the groups are not static so hardcoding the rows will not work). any ideas?

Hi, How do you recognize when the group changes?

each row in collum B contains the name which will be the same if the group is the same.

Kr.

Matthew

hey hi @Matthewvz , if my understanding is right you want to write each groups separately in excel file ? If it is so, You can sort the table using Sort table activity , then each group will segregated.

Thanks,
Uthraa

that is correct.

You can sort the table using Sort table activity , then each group will segregated.