I have rows that look like this

20050901 2343;3432
20060823 2232;2321
20050401 2322;4434

I want to parse the values into a separate sheet.

New sheet should look like:

Year Code
-------------------------
2005 2343
2005 3432
2006 2232
2006 2321
2005 2322
2005 4434

Any help would be appreciated.

Thanks