Solved

Group (Outline) set of data in Excel

Posted on 2014-10-22
6
97 Views
Last Modified: 2014-10-25
I would like to group 2011, 2012, 2013 , 2014, 2015 data separately to see data by year.
How do I do it as when i tried to click Group, it will group all the years together.
even when i do it separately, the group will extend to the final year - 2015.

Group.xlsx
0
Comment
Question by:ceneiqe
  • 4
  • 2
6 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40398427
Attached is the grouped file..
Group.xlsx
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40398428
When using group you need to select one column or row less than your actual range since the excel will use that as a display column. If you select whole year  and group it it will hide all the columns so you need to select jan-nov and the group will be created in dec column or you can select feb-dec and the group will be created in jan column
0
 

Author Comment

by:ceneiqe
ID: 40398595
I select column C to N and Group. this is ok.
But when i select column O to Z, it doesn't group it , but instead extend to Column Z. which means 2011 and 2012 is all into one.

but what i need is to be able to collapse and expand on a yearly basis.
meaning group Jan to Dec 2011, jan to dec 2012, jan to dec 2013 and so on.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40398659
If you are making two neighboring groups then the excel assumes ( wrongly) that it is the same group, to overcome that add additional column and then make group. You can use that column as total for the year or something like that...

Attached is the sample file...
Group.xlsx
0
 

Author Comment

by:ceneiqe
ID: 40398752
ok thks, i thought there is some workaround for this as i don't need an additional column for totals.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40399248
there is a option that you add an empty column and narrow it down to maximum ...

Anyway there must be blank column or Excel will join the groups,,,,
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now