Data table T
Source ID ID phone number
1 111 111 a
1 111 111 b
1 222 111 a
2 111 222 a
2 111 111 b
3 222 333 a
4, 333, 444 b


There are two records in the ID, the preferred source select a field
How to implement into
ID badge # 1 badge # 2 phone number 1 phone number 2
1, 111, 222, 111 null
2 111 222 111
null3 222 333 null null
4 333 444 null null