Confused by grouping/pivot/outline functions


N

Ned23

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.
 
Ad

Advertisements

D

Dave Peterson

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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top