title: How do I create one row from two rows of data in R? (Bracket example)
body: <p>I start with a data frame we will call DF1:</p>
  
  <pre><code>Team       Stat1     Stat2     Stat3    Stat4      Pod
  Georgia        1         3         3        6        1
  Nevada         2         2         2        7        2
  Clemson        3         1         2        4        2
  Texas          5         4         2        3        1
  </code></pre>
  
  <p>I want to use only Stats 1,2,3 (not 4). Based on the value in "Pod" I want to create a row with two teams. Each team would have Stats 1, 2, and 3. It should look something like this:</p>
  
  <pre><code>Team1     Stat1A     Stat2A     Stat3A     Team2     Stat1B     Stat2B     Stat3B
  Georgia        1          3         3      Texas          5         4           2
  Nevada         2          2         2      Clemson        3         1           2
  </code></pre>
  
  <p>This is supposed to indicate that Georgia and Texas are playing one another, Nevada and Clemson are playing, and so on. For every round in the tourney I would have to re-assign pods to the matchups in order to progress through the bracket. So, in this very simplified bracket example, the winner of each of the games would play, let's say Georgia faces Clemson in the final to get this:</p>
  
  <pre><code>Team1     Stat1A     Stat2A     Stat3A     Team2     Stat1B     Stat2B     Stat3B
  Georgia        1          3         3      Clemson        3         1           2
  </code></pre>