title: How to merge different excel sheets in R without any common column?
body: <p>I know how to combine data frames using merge function. I also tried importing excel sheets in different data frames but I am not able to merge since it doesn't have common columns. If you provide code in example, please be specific with only code related to excel sheets (merging excel sheets without common column and creating only a single excel sheet)</p>
  
  <p>After importing excel sheet, I tried importing sheets one by one in data frame but the question is how to merge these three and make one since it doesn't have common column. </p>
  
  <pre><code>x1 &lt;- data.frame(read_excel("Retail Data.xlsx", sheet=1))
  
  x2 &lt;- data.frame(read_excel("Retail Data.xlsx", sheet=2))
  
  x3 &lt;- data.frame(read_excel("Retail Data.xlsx", sheet=3))
  </code></pre>
  
  <p>And if I do:</p>
  
  <p>Customer_Final &lt;- data.frame(x1,x2,x3)</p>
  
  <p>shows error: Error in data.frame(x1, x2, x3) </p>