Respondent ID
(1)
Respondent choice
(2)
Added column for candidate 1
(3)
Added column for candidate 2
(4)
Difference between candidates 1 and 2
(5)=(3)–(4)
1 Candidate 1 1 0  1
2 Candidate 3 0 0  0
3 Candidate 2 0 1 –1
.. ……  …
N Candidate 1 1 0  1