Hi!
How can i get these results:
ID VAL
1 A
2 B
3 "a string"
4 C
5 "a string"
6 "a string"
7 "a string"
8 G
from:
ID VAL
1 A
1 x
1 A
1 x
1 A
1 A
1 A
2 B
2 B
2 B
2 x
2 B
2 x
3 A
3 A
3 K
3 A
3 A
3 A
4 C
4 C
4 x
4 C
4 C
4 x
4 C
5 D
5 B
5 D
5 D
5 D
6 E
6 F
6 E
6 M
6 E
7 L
7 F
7 F
8 G
8 G
8 G
8 G
8 G
8 G
Thanks in advance.