Hi,
Thanks in advance for any help. I'm wondering if there is an easy solution to this problem.
I have the following example data
ID ANIMALS
1 Cat
1 Dog
1 Lion
2 Cat
2 Lion
I wish to merge the ID data into one row and have the animals data flow along the colums like below..I just want all the data associated with that ID to be flowing along that row.
ID ANIMALS
1 Cat Dog Lion
2 Cat Lion
Is this possible in excel?Thanks
Bookmarks