I am dealing with data with information of different candidates, the results of each candidate is distributed by class 1, 2, 3, 4
Candidate A Name | Sex | Votes |Candidate B Name | Sex | Votes | Candidate C Name | Sex | Votes | Candidate D Name | Sex | Votes
Class 1
Class 2
Class 3
Class 4
Firstly, I wish to group the columns of the information of a candidate, such that
Group A [ contains Candidate A Name | Sex | Votes of Candidate A]
Group B [ contains Candidate B Name | Sex | Votes of Candidate B]
​​​​​​​Group C [ contains Candidate B Name | Sex | Votes of Candidate C]

After that, I wish to compare the number of votes of each candidate, and to Generate the name of the candidate only with the Highest Result into a new column

For example, if Candidate D obtains highest number of vote, name fo Candaidate D will be generate in a new column

​​​​​​​Thank you in advance