Rearrange columns with partial matching numbers

I'll be working with three columns, including column A, which has the full number for an event; Ecode, which will have a partial number (the last five digits of column A); and column C, which will ha...