Hi there,
I have a set of data in the below format in excel.
Names Items
John Pen
John Pencil
James Pen
James Scale
James Eraser
Jeremy Pen
Jeremy File
Which I wanted to change it into the below format.
Names Item1 Item2 Item3
John Pen Pencil
James Pen Scale Eraser
Jeremy Pen File
How can I do this quickly and in a easy way? Kindly help.
Bookmarks