Hi all,

I'm sure this topic must have come up before but I couldn't find anything - apologies if you've read it all before.

Basically, I have 2 columns - one with an ID and the other with another different ID. Each of the IDs in the second column is unique and are related to an ID in the first column like this:

89 4652
89 8979
89 9567
141 5025
141 6521
189 5684

Is there a way of changing this so that I only have one row for each ID in the first column, and then all the relevant IDs from the second column are listed in seperate columns like this:

89 4652 8979 9567
141 5025 6521
189 5684

Thanks for reading my post - I hope you can help!