title: Is there a specific way to use tidyr to manipulate data into workable columns?
body: <p>I am working with a dataset from a herbicide experiment involving different
  herbicides and their ratings. I'm trying to use tidyr to manipulate the
  data. Here's what I'm working with:</p>
  
  <pre><code>library(readr)
  
  library(tidyr)
  
  library(dplyr)
  
  
  plot &lt;- c("101","102","103","104")
  herbicide &lt;- c("mesotrione","tembotrione","mesotrione","tembotrione")
  plant_1 &lt;- c("100","100","95","95")
  plant_2 &lt;- c("100","100","95","20")
  plant_3 &lt;- c("50","50","50","50")
  plant_4 &lt;- c("40","40","30","30")
  
  dataframe1&lt;- as.data.frame(cbind(plot, herbicide, plant_1, plant_2, plant_3,
  plant_4))
  </code></pre>
  
  <p>I want to manipulate this data so that I will have the data sorted in
  columns as follows:</p>
  
  <pre><code>plot &lt;-
  c("101","101","101","101","102","102","102","102","103","103","103","103","104","104","104","104")
  
  herbicide &lt;-
  c("mesotrione","mesotrione","mesotrione","mesotrione","tembotrione","tembotrione","tembotrione","tembotrione",              
  "mesotrione","mesotrione","mesotrione","mesotrione","tembotrione","tembotrione","tembotrione","tembotrione")
  
  plant &lt;- c("1","2","3","4","1","2","3","4","1","2","3","4","1","2","3","4")
  
  score &lt;-
  c("100","100","95","95","100","100","95","20","50","50","50","50","40","40","30","30")
  
  dataframe2 &lt;- as.data.frame(cbind(plot, herbicide, plant, score))
  </code></pre>
  
  <p>This is what I have tried, but it doesn't work for me:</p>
  
  <pre><code>sort &lt;- gather(data1, plot, plant_score, herbicide)
  </code></pre>
  
  <p>Any help would be greatly appreciated, thanks everyone!</p>