Combine Same Item Number into one cell Like concatinate function. : 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. 

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. 

    =concatenate(E,F)

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

The structure of excel is as under. 

[enter image description here][1]


  [1]: https://i.stack.imgur.com/JL8YH.png