Suppress duplicate data

[Prema]

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.

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

[Stefi]

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