software

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.you have a suggestion at your other thread in .misc.

Prema wrote:
gt;
gt; I have a worksheet where data could be the same for first two columns of some
gt; rows. I would like to supress this and show the data only on one line.
gt; e.g if I my data is like
gt; Apples green type1 10
gt; Apples green type2 12
gt; Apples red type1 9
gt; Apples red type3 21
gt; Pears green type2 5
gt; Pears green type1 14
gt;
gt; Then I would like it to be displayed as
gt; Apples green type1 10
gt; type2 12
gt; red type1 9
gt; type3 21
gt; Pears green type2 5
gt; type1 14
gt;
gt; What do I have to do to achieve this?
gt; Thank you for any help.
gt;

--

Dave Peterson

Suppose your columns are as follows:

A B C D
gt; Apples green type1 10

Insert two new columns between B and C:
A B C D E F
gt; Apples green type1 10Enter this formula in C2 (row1 is supposed as a header):

=IF(A2=A1,quot;quot;,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?rema??ezt ?rta:

gt; I have a worksheet where data could be the same for first two columns of some
gt; rows. I would like to supress this and show the data only on one line.
gt; e.g if I my data is like
gt; Apples green type1 10
gt; Apples green type2 12
gt; Apples red type1 9
gt; Apples red type3 21
gt; Pears green type2 5
gt; Pears green type1 14
gt;
gt; Then I would like it to be displayed as
gt; Apples green type1 10
gt; type2 12
gt; red type1 9
gt; type3 21
gt; Pears green type2 5
gt; type1 14
gt;
gt; What do I have to do to achieve this?
gt; Thank you for any help.
gt;