suppress duplicate leading cells
 

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 leading cells
 

You could use Format|conditional Formatting.

The values are still there, but the cells look empty:

See Debra Dalgleish's site:
http://www.contextures.com/xlCondFor...html#Duplicate

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 leading cells
 

you could write a simple macro that checks each cell in col 1 and col 2

eg if a2=a1 then delete a2

apples GREEN TYPE1 10
apples GREEN TYPE2 12
pears GREEN TYPE2 30

becomes

apples GREEN TYPE1 10
TYPE2 12
pears GREEN TYPE2 30


Then you could concatenate A1,B1,C1,D1
A2,B2,C2,D2 ETC ETC

AND PUT THE RESULT IN ONE CELL IF YOU DESIRE

A B C D E
TYPE2 10 TYPE2 10


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=527096