Rows to Columns

ID Acct
39425 Fund1
39425 Fund2
39425 Fund3
39425 Fund4
33256 Fund3
33256 Fund4


Here is a result of a database with 2 columns. Anyone know of a code that will put all the data in one row by ID?

e.g.
ID Acct Acct2 Acct3 Acct4
39425 Fund1 Fund2 Fund3 Fund4
33256 Fund3 Fund4

Did you ever manage to solve this one, I am having the exact same problem. My problem may have different lengths to the Acct fields for example

ID ACCTs

1 4234 4235 4236
2 4237 4238
3 4329 4239 4240 4241

Can anyone please help with this?

Sorry not really. I ended up putting it to excel and doing steps to fix it. However I am still tying so will post if/when I figure it out.