Moving Rows Data Into Columns ..

Hi guys,
I have a table with the following structure
ID CodeID Code Desc
1 10 AA AAAAAAA
2 20 BB BBBBBBBB
3 30 CC CCCCCCCC
4 10 DD DDDDDDDD
5 20 EE EEEEEEEEEE

Now I need to create a new table with the following structure

CodeID AA BB CC DD EE
10 AAAAAAAA Null Null DDDDDD Null
20 Null BBBBBBBB Null Null EEEEEEEEE
30 Null Null CCCCCCCC Null Null

I have managed to create a logic that solve this problem by selecting all AA values and insert it to the new table and then using a series of update statements I updated the values of BB, CC, DD €¦€¦ The problem is that I have to do a 30 update statement so the performance is very bad.
Are there any better solution to implement this table using SSIS that could give me a better performance ?

Thanks a lot.