Changing the layout of data

[zopm]

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

[:) Sixthsense :)]

Refer Post #4 of the below link
http://www.excelforum.com/excel-form...e-returns.html