organizing sheet

[steve]

I have a sheet full of customer info. There is a column titled customers
name. But for each customer, sometimes there may be up to ten rows of info,
then it goes to the next customer who may only have 3. is there an option to
consolidate all the rows into one row with the customers name, then the user
has the option to view the other rows. i was thinking like a folder, how you
hit the plus sign and you can see the sub folders or files. i know this is a
long shot, but if anyone can help i'd appreciate it.

steve

[K Dales]

Have you tried Data... Subtotals (from the menus); this might be enough to do
what you want.

"steve" wrote:

> I have a sheet full of customer info. There is a column titled customers
> name. But for each customer, sometimes there may be up to ten rows of info,
> then it goes to the next customer who may only have 3. is there an option to
> consolidate all the rows into one row with the customers name, then the user
> has the option to view the other rows. i was thinking like a folder, how you
> hit the plus sign and you can see the sub folders or files. i know this is a
> long shot, but if anyone can help i'd appreciate it.
>
> steve

[Sean Connolly]

Hi,

If additional rows for subtotals are not necessarily required, Data ...
Group and Outline might also be useful.

"K Dales" wrote:

> Have you tried Data... Subtotals (from the menus); this might be enough to do
> what you want.
>
> "steve" wrote:
>
> > I have a sheet full of customer info. There is a column titled customers
> > name. But for each customer, sometimes there may be up to ten rows of info,
> > then it goes to the next customer who may only have 3. is there an option to
> > consolidate all the rows into one row with the customers name, then the user
> > has the option to view the other rows. i was thinking like a folder, how you
> > hit the plus sign and you can see the sub folders or files. i know this is a
> > long shot, but if anyone can help i'd appreciate it.
> >
> > steve