Spreadsheet: 862850d1710430332-show-unique-results-from-a-list-only-once-sample
Sheet: Sheet1

Raw Data, need column B to repeat th reference from A but only on one instance. |  |  |  |  |  | This has been done manaully to show desired result
[NAME] | [NAME] |  |  |  |  | [NAME] | [NAME]
SOD-01246058 |  |  |  |  |  | SOD-01246058 | SOD-01246058
SOD-01225054 | SOD-01225054 |  |  |  |  | SOD-01225054 | SOD-01225054
SOD-01228936 | SOD-01228936 |  |  |  |  | SOD-01228936
SOD-01262640 | SOD-01262640 |  |  |  |  | SOD-01262640
SOD-01249137 | SOD-01249137 |  |  |  |  | SOD-01249137
SOD-01248851 | SOD-01248851 |  |  |  |  | SOD-01248851
SOD-01218377 | SOD-01218377 |  |  |  |  | SOD-01218377
SOD-01196110 | SOD-01196110 |  |  |  |  | SOD-01196110
SOD-01196092 | SOD-01196092 |  |  |  |  | SOD-01196092
SOD-01197478 | SOD-01197478 |  |  |  |  | SOD-01197478
SOD-01205102 | SOD-01205102 |  |  |  |  | SOD-01205102
SOD-01205102 |  |  |  |  |  | SOD-01205102
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01197250 | SOD-01197250 |  |  |  |  | SOD-01197250
SOD-01196804 | SOD-01196804 |  |  |  |  | SOD-01196804
SOD-01204223 | SOD-01204223 |  |  |  |  | SOD-01204223
SOD-01208545 | SOD-01208545 |  |  |  |  | SOD-01208545
SOD-01229045 | SOD-01229045 |  |  |  |  | SOD-01229045
SOD-01223820 | SOD-01223820 |  |  |  |  | SOD-01223820
SOD-01253877 | SOD-01253877 |  |  |  |  | SOD-01253877
SOD-01246058 |  |  |  |  |  | SOD-01246058
SOD-01220782 | SOD-01220782 |  |  |  |  | SOD-01220782
SOD-01215728 | SOD-01215728 |  |  |  |  | SOD-01215728
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01246058 |  |  |  |  |  | SOD-01246058
SOD-01229045 |  |  |  |  |  | SOD-01229045
SOD-01246262 | SOD-01246262 |  |  |  |  | SOD-01246262
SOD-01215728 |  |  |  |  |  | SOD-01215728
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01218504 | SOD-01218504 |  |  |  |  | SOD-01218504
SOD-01253877 |  |  |  |  |  | SOD-01253877
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01196110 |  |  |  |  |  | SOD-01196110
SOD-01196110 |  |  |  |  |  | SOD-01196110
SOD-01208545 |  |  |  |  |  | SOD-01208545
SOD-01253877 |  |  |  |  |  | SOD-01253877
SOD-01220782 |  |  |  |  |  | SOD-01220782
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01253877 |  |  |  |  |  | SOD-01253877
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01246262 |  |  |  |  |  | SOD-01246262
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01208545 |  |  |  |  |  | SOD-01208545
SOD-01208545 |  |  |  |  |  | SOD-01208545
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01208545 |  |  |  |  |  | SOD-01208545
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01208545 |  |  |  |  |  | SOD-01208545
SOD-01197250 |  |  |  |  |  | SOD-01197250
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01257634 | SOD-01257634 |  |  |  |  | SOD-01257634
SOD-01262640 |  |  |  |  |  | SOD-01262640
SOD-01262640 |  |  |  |  |  | SOD-01262640
SOD-01246262 |  |  |  |  |  | SOD-01246262
SOD-01205102 |  |  |  |  |  | SOD-01205102
SOD-01221442 | SOD-01221442 |  |  |  |  | SOD-01221442
SOD-01217655 | SOD-01217655 |  |  |  |  | SOD-01217655
SOD-01217655 |  |  |  |  |  | SOD-01217655
SOD-01257634 |  |  |  |  |  | SOD-01257634
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01197250 |  |  |  |  |  | SOD-01197250
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01197478 |  |  |  |  |  | SOD-01197478
SOD-01217655 |  |  |  |  |  | SOD-01217655
SOD-01246262 |  |  |  |  |  | SOD-01246262
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01253877 |  |  |  |  |  | SOD-01253877
SOD-01197250 |  |  |  |  |  | SOD-01197250
SOD-01220782 |  |  |  |  |  | SOD-01220782
SOD-01229045 |  |  |  |  |  | SOD-01229045
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01205102 |  |  |  |  |  | SOD-01205102
SOD-01196092 |  |  |  |  |  | SOD-01196092
SOD-01211407 | SOD-01211407 |  |  |  |  | SOD-01211407
SOD-01257634 |  |  |  |  |  | SOD-01257634
SOD-01228811 | SOD-01228811 |  |  |  |  | SOD-01228811
SOD-01257634 |  |  |  |  |  | SOD-01257634
SOD-01228811 |  |  |  |  |  | SOD-01228811
SOD-01228811 |  |  |  |  |  | SOD-01228811
SOD-01228811 |  |  |  |  |  | SOD-01228811
SOD-01228811 |  |  |  |  |  | SOD-01228811
SOD-01220782 |  |  |  |  |  | SOD-01220782
SOD-01220782 |  |  |  |  |  | SOD-01220782
SOD-01220782 |  |  |  |  |  | SOD-01220782
SOD-01246058 |  |  |  |  |  | SOD-01246058
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01223820 |  |  |  |  |  | SOD-01223820
SOD-01246262 |  |  |  |  |  | SOD-01246262
SOD-01199096 | SOD-01199096 |  |  |  |  | SOD-01199096
SOD-01213212 | SOD-01213212 |  |  |  |  | SOD-01213212
SOD-01196804 |  |  |  |  |  | SOD-01196804
SOD-01196804 |  |  |  |  |  | SOD-01196804
SOD-01199096 |  |  |  |  |  | SOD-01199096
SOD-01199096 |  |  |  |  |  | SOD-01199096
SOD-01199096 |  |  |  |  |  | SOD-01199096
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01264990 | SOD-01264990 |  |  |  |  | SOD-01264990
SOD-01228936 |  |  |  |  |  | SOD-01228936
SOD-01228936 |  |  |  |  |  | SOD-01228936
SOD-01248851 |  |  |  |  |  | SOD-01248851
SOD-01228936 |  |  |  |  |  | SOD-01228936
SOD-01215728 |  |  |  |  |  | SOD-01215728
SOD-01217663 | SOD-01217663 |  |  |  |  | SOD-01217663
SOD-01199096 |  |  |  |  |  | SOD-01199096
SOD-01210896 | SOD-01210896 |  |  |  |  | SOD-01210896
SOD-01248851 |  |  |  |  |  | SOD-01248851
SOD-01228936 |  |  |  |  |  | SOD-01228936
SOD-01254463 | SOD-01254463 |  |  |  |  | SOD-01254463
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01254463 |  |  |  |  |  | SOD-01254463
SOD-01228936 |  |  |  |  |  | SOD-01228936
SOD-01196804 |  |  |  |  |  | SOD-01196804
SOD-01199096 |  |  |  |  |  | SOD-01199096
SOD-01196804 |  |  |  |  |  | SOD-01196804
SOD-01213212 |  |  |  |  |  | SOD-01213212
SOD-01254463 |  |  |  |  |  | SOD-01254463
SOD-01213212 |  |  |  |  |  | SOD-01213212
SOD-01213212 |  |  |  |  |  | SOD-01213212
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01225054 |  |  |  |  |  | SOD-01225054
SOD-01248851 |  |  |  |  |  | SOD-01248851
SOD-01213212 |  |  |  |  |  | SOD-01213212
SOD-01213212 |  |  |  |  |  | SOD-01213212
SOD-01211407 |  |  |  |  |  | SOD-01211407
SOD-01197250 |  |  |  |  |  | SOD-01197250
SOD-01262640 |  |  |  |  |  | SOD-01262640
SOD-01229045 |  |  |  |  |  | SOD-01229045
SOD-01254463 |  |  |  |  |  | SOD-01254463
SOD-01221442 |  |  |  |  |  | SOD-01221442
SOD-00918268 | SOD-00918268 |  |  |  |  | SOD-00918268
SOD-01155387 | SOD-01155387 |  |  |  |  | SOD-01155387
SOD-01063695 | SOD-01063695 |  |  |  |  | SOD-01063695
SOD-01063695 |  |  |  |  |  | SOD-01063695
SOD-01063695 |  |  |  |  |  | SOD-01063695
SOD-01063695 |  |  |  |  |  | SOD-01063695
SOD-01234493 | SOD-01234493 |  |  |  |  | SOD-01234493
SOD-01234493 |  |  |  |  |  | SOD-01234493
SOD-01234493 |  |  |  |  |  | SOD-01234493
SOD-01234493 |  |  |  |  |  | SOD-01234493
SOD-01234493 |  |  |  |  |  | SOD-01234493
SOD-01234493 |  |  |  |  |  | SOD-01234493
SOD-01090142 | SOD-01090142 |  |  |  |  | SOD-01090142
SOD-01255946 | SOD-01255946 |  |  |  |  | SOD-01255946
SOD-01206571 | SOD-01206571 |  |  |  |  | SOD-01206571
SOD-01217765 | SOD-01217765 |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01262519 | SOD-01262519 |  |  |  |  | SOD-01262519
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01262519 |  |  |  |  |  | SOD-01262519
SOD-01217765 |  |  |  |  |  | SOD-01217765
SOD-01193239 | SOD-01193239 |  |  |  |  | SOD-01193239
SOD-01193239 |  |  |  |  |  | SOD-01193239
SOD-01206571 |  |  |  |  |  | SOD-01206571
SOD-01206571 |  |  |  |  |  | SOD-01206571
SOD-01206571 |  |  |  |  |  | SOD-01206571
SOD-01257040 | SOD-01257040 |  |  |  |  | SOD-01257040
SOD-01224549 | SOD-01224549 |  |  |  |  | SOD-01224549
SOD-01257040 |  |  |  |  |  | SOD-01257040
SOD-01210957 | SOD-01210957 |  |  |  |  | SOD-01210957
SOD-01246187 | SOD-01246187 |  |  |  |  | SOD-01246187
SOD-01246187 |  |  |  |  |  | SOD-01246187
SOD-01260465 | SOD-01260465 |  |  |  |  | SOD-01260465
SOD-01210957 |  |  |  |  |  | SOD-01210957
SOD-01187994 | SOD-01187994 |  |  |  |  | SOD-01187994
SOD-01206939 | SOD-01206939 |  |  |  |  | SOD-01206939
SOD-01143739 | SOD-01143739 |  |  |  |  | SOD-01143739
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01210957 |  |  |  |  |  | SOD-01210957
SOD-01247952 | SOD-01247952 |  |  |  |  | SOD-01247952
SOD-01247952 |  |  |  |  |  | SOD-01247952
SOD-01246187 |  |  |  |  |  | SOD-01246187
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01206571 |  |  |  |  |  | SOD-01206571
SOD-01210957 |  |  |  |  |  | SOD-01210957
SOD-01210957 |  |  |  |  |  | SOD-01210957
SOD-01206939 |  |  |  |  |  | SOD-01206939
SOD-01247952 |  |  |  |  |  | SOD-01247952
SOD-01246187 |  |  |  |  |  | SOD-01246187
SOD-01255946 |  |  |  |  |  | SOD-01255946
SOD-01257040 |  |  |  |  |  | SOD-01257040
SOD-01260465 |  |  |  |  |  | SOD-01260465