Suppress duplicate data

[Guest]

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]

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

 

[Guest]

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 C22 and fill it down as necessary!

You can hide columns A:B if you want!

Regards,
Stefi


„Prema†ezt írta: