I have a table with months in the column field. Each month has 4 columns of data. Column A are the items, column B to E is the data for month of Jan, column F to I is for Feb and so on.
I would like to group the months so that I might have the option to only see a particular. But the items in column A should still be there.
Problem is that if I group B to E then F to I, excel automatically groups B to I as one group.
Is there a way to go around this?
Thanks
I would like to group the months so that I might have the option to only see a particular. But the items in column A should still be there.
Problem is that if I group B to E then F to I, excel automatically groups B to I as one group.
Is there a way to go around this?
Thanks