title: Combine Same Item Number into one cell Like concatinate function
body: <p>Hy Experts, I have an excel sheet with four columns. Column 1 is Part_No, Column 2 is Type, Column 3 is Col2 as Year and column 4 is Item Name. </p>
  
  <p>Actually the column 1 as C column contains many Part_No with same number like 08256 is in sheet 2 times as row one and two. But in some cases the rows are very far from the same number. I used simple this function. </p>
  
  <pre><code>=concatenate(E,F)
  </code></pre>
  
  <p>It can combine only one row but I want to combine all the rows in one cell that have same Part_No. How it could be. Thanks</p>
  
  <p>The structure of excel is as under. </p>
  
  <p><img src="https://i.stack.imgur.com/JL8YH.png" alt="enter image description here"></p>