I used the alphabetical sort to analyze 25,000 rows and several columns. Somehow, I sorted one of the columns independent from the others, so I need a script to unshuffle the columns as shown:
Unshuffled Column (desired output)
I have the unshuffled columns for the script to work from. The problem is that I deleted several rows from from the shuffled data. See attached file for a sample of the problem (the names in red need to be corrected). The actual script will need to sort through 15,000 shuffled rows by picking out the correct name from 25,000 unshuffled rows.
I am looking to do this project immediately.