Forum Discussion

cnido's avatar
cnido
Copper Contributor
Sep 10, 2024

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 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. 

 

 

Resources