Suppress duplicate data
 

I have a worksheet where data could be the same for first two columns of some
rows. I would like to supress this and show the data only on one line.
e.g if I my data is like
Apples green type1 10
Apples green type2 12
Apples red type1 9
Apples red type3 21
Pears green type2 5
Pears green type1 14

Then I would like it to be displayed as
Apples green type1 10
type2 12
red type1 9
type3 21
Pears green type2 5
type1 14

What do I have to do to achieve this?
Thank you for any help.

Suppress duplicate data
 

you have a suggestion at your other thread in .misc.

Prema wrote:

I have a worksheet where data could be the same for first two columns of some
rows. I would like to supress this and show the data only on one line.
e.g if I my data is like
Apples green type1 10
Apples green type2 12
Apples red type1 9
Apples red type3 21
Pears green type2 5
Pears green type1 14

Then I would like it to be displayed as
Apples green type1 10
type2 12
red type1 9
type3 21
Pears green type2 5
type1 14

What do I have to do to achieve this?
Thank you for any help.


--

Dave Peterson

Suppress duplicate data
 

Suppose your columns are as follows:

A B C D
Apples green type1 10

Insert two new columns between B and C:
A B C D E F
Apples green type1 10


Enter this formula in C2 (row1 is supposed as a header):

=IF(A2=A1,"",A2)
and fill it right to D2 then select C2:D2 and fill it down as necessary!

You can hide columns A:B if you want!

Regards,
Stefi


€žPrema€� ezt Ã*rta:

I have a worksheet where data could be the same for first two columns of some
rows. I would like to supress this and show the data only on one line.
e.g if I my data is like
Apples green type1 10
Apples green type2 12
Apples red type1 9
Apples red type3 21
Pears green type2 5
Pears green type1 14

Then I would like it to be displayed as
Apples green type1 10
type2 12
red type1 9
type3 21
Pears green type2 5
type1 14

What do I have to do to achieve this?
Thank you for any help.