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 have a score related to column B. The difficult thing I’m trying to figure out is how to rearrange column B (and, by extension, C) so they match up with the full numbers of column A without moving the values of column A. 

​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 have a score related to column B. The difficult thing I’m trying to figure out is how to rearrange column B (and, by extension, C) so they match up with the full numbers of column A without moving the values of column A.     Read More

​