cpmurray1985
New Member
- Joined
- Mar 10, 2022
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hello!
I'm sure this is simple, but I appear to be running into an issue. I am trying to filter a chart based on group, so that whenever I select the specific group, it pulls the rows with it. However, it will only display the group name and the same row line.
For example, what I would have:
What I want if I sort by Group A
What I get instead:
Is something like this possible even if there are spaces above and below Group A? I have over 200+ groups I need to filter that have three rows associated like above, with a blank cell above and below. I tried merging cells, indexing, but it didn't seem to help.
I'm sure this is simple, but I appear to be running into an issue. I am trying to filter a chart based on group, so that whenever I select the specific group, it pulls the rows with it. However, it will only display the group name and the same row line.
For example, what I would have:
Group | Column B | Column C | Column D | Column F | |
---|---|---|---|---|---|
1 | 3 | 9 | |||
Group A | X | 2 | 2 | 8 | |
3 | 1 | 7 | |||
Group B | Y | 4 | 6 | A | |
5 | 5 | B | |||
6 | 4 | C |
What I want if I sort by Group A
Group | Column B | Column C | Column D | Column F | |
---|---|---|---|---|---|
1 | 3 | 9 | |||
Group A | X | 2 | 2 | 8 | |
3 | 1 | 7 | |||
What I get instead:
Group | Column B | Column C | Column D | Column F | |
---|---|---|---|---|---|
Group A | x | 2 | 2 | 8 |
Is something like this possible even if there are spaces above and below Group A? I have over 200+ groups I need to filter that have three rows associated like above, with a blank cell above and below. I tried merging cells, indexing, but it didn't seem to help.