I have a dataframe df of soccer team information by game (MATCHID) with these initial values TEAMID Venue LEAGUEPOS MATCHID WHU A 5 1 COV H 12 1 EVE H 15 2 MNU A 2 2 ARS A 3 3 LEI H 4 3 I wish to create just one row for each game so that it would end up looking like MATCHID HomeTeam AwayTeam HomePos AwayPos 1 COV WHU 12 5 etc. so I want to create some new columns , delete others and remove duplicated rows. I am having trouble with first stage trying df$HomeTeam