If you have information in columns that is duplicates, is there any way to only print the first field in the group.
Example:
ColA ColB ColC ColD
1 TAB ADJ 87
1 TAB ADJ 98
1 TAB ADJ 102
1 TAB ADJ lbj
1 TAB ADJ 09
1 TAB MEK bef
1 TAB MEK bvc
1 TAB MEK 87j
1 TAB MEK 34g
1 TAB MEK gf7
What I would like to do is make it where the duplicates aren't shown. For instance if there are 50 rows of the same thing, can I make it appear in row 1 and not show the 1 or TAB all the way down the column to row 50 in the example for colA.
Thanks
This message was edited by lenny on 2002-05-13 01:28
This message was edited by Lenny on 2002-05-13 01:30
Example:
ColA ColB ColC ColD
1 TAB ADJ 87
1 TAB ADJ 98
1 TAB ADJ 102
1 TAB ADJ lbj
1 TAB ADJ 09
1 TAB MEK bef
1 TAB MEK bvc
1 TAB MEK 87j
1 TAB MEK 34g
1 TAB MEK gf7
What I would like to do is make it where the duplicates aren't shown. For instance if there are 50 rows of the same thing, can I make it appear in row 1 and not show the 1 or TAB all the way down the column to row 50 in the example for colA.
Thanks
This message was edited by lenny on 2002-05-13 01:28
This message was edited by Lenny on 2002-05-13 01:30