Hi
I have an excel file looking something like this:
| Company | Year | Month | Day | Count |
| Comp1 | 2016 | 1 | 1 | 2 |
| Comp1 | 2016 | 1 | 3 | 1 |
| Comp1 | 2016 | 1 | 4 | 3 |
| Comp1 | 2016 | 2 | 1 | 4 |
| Comp1 | | | | 10 |
| Comp2 | 2016 | 1 | 1 | 1 |
| Comp2 | 2016 | 1 | 2 | 3 |
| Comp2 | 2016 | 1 | 3 | 5 |
| Comp2 | 2016 | 2 | 2 | 2 |
| Comp2 | 2016 | 3 | 3 | 3 |
| Comp2 | 2016 | 3 | 4 | 1 |
| Comp2 | | | | 15 |
| Comp3 | 2016 | 1 | 1 | 2 |
| Comp3 | 2016 | 1 | 2 | 3 |
| Comp3 | | | | 5 |
What i want to do is run through this sheet and group rows according to Company so i get that little "+" or "-" button beside the group.
The number of rows for each company will not be the same every time this excel file is created, so i can't just say "make cell A1 to A5 a group". i have to do this dynamically.
I have tried to google this but i can't find the answer. The problem could be that i simply just don't know how to write this problem in a search string for google.
Is this at all possible (i think it is) and how do i do this?
I hope some of you in here can help me.