Have a Tiered Table For Ease of viewing

[Traps]

I am looking to make a Table for customers, but each customer will have several departments in it for instance:

Customer	Departmemt
Cust 1
	Dept A
	Dept B
	Dept C
Cust 2
	Dept A
	Dept B
	Dept C

Ideally the first line of each customer would be the summary information and the departments would be the department specific information.

Is there a way to make it so I can Hide the departments so that I can compare just the summary information?
So Clicking on cust 2 would expand the rows to show Dept A, B and C?

 

[severynm]

What you want is to Group (or Outline) rows. On the Data tab, Outline -> Group/Ungroup.