Forum Discussion
Need help to find grouped rows Excel
I have a problem with grouping in the pivot table. When I group a few rows, those rows totally disappear. I tried different methods to find them but haven’t been successful yet. For context, there ...
Alex2420 Please upload a file that demonstrates your problem. Quite difficult to help based on your description alone.
Sorry, can’t share the file because of sensitive data. I may have to create another one just to demonstrate. It is basically like this.
I see 81 rows in one sheet. I need to group them into four. When I make the first group of 8, I don’t see any of them or the title ‘group’. When I make all the four groups, all rows disappear.
Now I used a filter by label in the beginning. I think that might be causing the problem as I still see the filter is active. I can’t delete the filter.
I see 81 rows in one sheet. I need to group them into four. When I make the first group of 8, I don’t see any of them or the title ‘group’. When I make all the four groups, all rows disappear.
Now I used a filter by label in the beginning. I think that might be causing the problem as I still see the filter is active. I can’t delete the filter.
Alex2420 Please do an example without sensitive data.