Collapsable option for data

[Cremorneguy]

Hi,

Not sure if this is the correct forum.

I have a spreadsheet with multiple columns and data. I want to make each column like a collapsable option.

The first column is the year, followed by the month then a type of service. I want it so that i can collapse the data so that the first column has the year with a "+" to collapse the next column to show the month, then another collapse to show the type of service. Someone told me about a pivot table but i couldn't enter any new data and couldn't get rid of the totals count as i don't need this.

I unfortunately don't have a copy of what i want as this computer doesn't support it.

Basically, a bit of an example would be:

+ 2011
+ 2012
+ 2013
+ January
+ February
+ Mail Services
+ Print Services
Volumes
Comments
+ 2014
+ 2015

Hopefully that appears the way i want. Next to "Volumes" and "Comments" i want to be able to enter data. I'm not sure if anyone can help but if you can i would greatly appreciate it!

Many thanks

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.