Hi Kam,
I assume you have a reason for grouping in that way, maybe a cost center or
department so what you can do is add a column to your information let's say
"Departments" and then assign a department to each line. When doing the Pivot
table you select the departments then you are able to expand the department
you want or have just the summary

"KAM" wrote:

I have a data sheet that I would like to creat a pivot table off of. My
problem is line 2, 3, 4, and 5 I would like to keep together and 6, 7, 8 and
9 should display togther, and so on.... I am not a pivot table queen so just
wonder if there's someone out there that know's how to do this or if it can
be done..