I am using Access I have this:
TABLE A
Slide Position GO ID
1
2
3
4 GO:0000166
4 GO:0000775
4 GO:0000795
4 GO:0000800
4 GO:0003677
5
6
7
8 GO:0042802
9
10 GO:0003779
10 GO:0005509
And would like to get this
TABLE B
Slide Position GO ID
1
2
3
4 GO:0000166, GO:0000775, GO:0000795, GO:0000800, GO:0003677
5
6
7
8 GO:0042802
9
10 GO:0005509, GO:0005856, GO:0007010, GO:0016020, GO:0051016
I already have created a table with "Slide Position" as primary key (TABLE C), but I don't get something similar to Table B
TABLE C with single column (and primary key)
Slide Position
1
2
3
4
5
6
7
8
9
10
Is there any way to create TABLE B?
thanks