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

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

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