Soldato
I have two columns of information, A which is an ID and B which is a value.
I wish to sort this so that any multiple ID's are given a 'multiple' value..
e.g.
A B
1 apples
2 oranges
2 pears
2 bananas
3 strawberries
4 grapes
4 kiwi
5 lychees
Would become:
A B
1 apples
2 multiple
3 strawberries
4 multiple
5 lychees
Any ideas?
PHP would be nicest as the source data is tab. delim.
Cheers!
JD
I wish to sort this so that any multiple ID's are given a 'multiple' value..
e.g.
A B
1 apples
2 oranges
2 pears
2 bananas
3 strawberries
4 grapes
4 kiwi
5 lychees
Would become:
A B
1 apples
2 multiple
3 strawberries
4 multiple
5 lychees
Any ideas?
PHP would be nicest as the source data is tab. delim.
Cheers!
JD