Hello guys,
I am using xl since years but I am stuck at one point which I can not give a solution.
I have cells as below:
Item1, Model1
Item1, Model2
Item1, Model3
Item2, Model2
Item2, Model4
I need to result as below:
Item1, Model1;Model2;Model3
Item2, Model2;Model4
I have tried countif to get the counted repeating "itemX" but I can not group the models together.
Please some help is highly appreciated.
Thank You
Jon
I am using xl since years but I am stuck at one point which I can not give a solution.
I have cells as below:
Item1, Model1
Item1, Model2
Item1, Model3
Item2, Model2
Item2, Model4
I need to result as below:
Item1, Model1;Model2;Model3
Item2, Model2;Model4
I have tried countif to get the counted repeating "itemX" but I can not group the models together.
Please some help is highly appreciated.
Thank You
Jon