Confused by grouping/pivot/outline functions
 

I'm trying to group a worksheet according to repeating values in the first
column. All of the data in the rest of the columns is unique to each row,
but the values in the first column repeat up to a dozen times. What I want
to do is add one of those [+] things to the worksheet that collapses only the
first column into a heading but leaves all of the other unique columns
intact. I'm not sure exactly which function I need to use. An
illustration is below:

I've got something like this (comma delimits a column):

Apple, 20, 40, 50
Apple, 30, 50, 10
Apple, 25, 35, 45
Pear, 10, 10, 20
Pear, 15, 15, 15

And I want to hit a [+] sign to make it look like this for display:

Apple
20, 40, 50
30, 50, 10
25, 35, 45
Pear
10, 10, 10
15, 15, 15

Does that make sense?

Thanks.

Confused by grouping/pivot/outline functions
 

I don't think that there's anything built into excel that will do this.

But maybe you could group your data (data|group and outline) to get the
outlining symbols and use format|conditional formating to "hide" the duplicates
in column A.

Debra Dalgleish shows the conditional formatting technique:
http://contextures.com/xlCondFormat03.html#Duplicate

Ned23 wrote:

I'm trying to group a worksheet according to repeating values in the first
column. All of the data in the rest of the columns is unique to each row,
but the values in the first column repeat up to a dozen times. What I want
to do is add one of those [+] things to the worksheet that collapses only the
first column into a heading but leaves all of the other unique columns
intact. I'm not sure exactly which function I need to use. An
illustration is below:

I've got something like this (comma delimits a column):

Apple, 20, 40, 50
Apple, 30, 50, 10
Apple, 25, 35, 45
Pear, 10, 10, 20
Pear, 15, 15, 15

And I want to hit a [+] sign to make it look like this for display:

Apple
20, 40, 50
30, 50, 10
25, 35, 45
Pear
10, 10, 10
15, 15, 15

Does that make sense?

Thanks.

--

Dave Peterson