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