In Progress

Visual Basic or Excel (Open Office) unshuffle two columns

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:

Shuffled Columns:

COLUMN1 COLUMN2

ID#1 NAME#493

Unshuffled Column (desired output)

COLUMN1 COLUMN2

ID#1 NAME#1

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.

Skills: Excel, Visual Basic

See more: open office project, Visual Basic Excel, sort excel, project office, picking, open file, open data, excel visual basic, do excel, data visual, excel sample project data, sample visual basic excel, open project script, visual basic problem, work visual, excel sample file, file name excel, excel rows, file open, sort problem, columns excel, need visual, need visual basic, open file excel visual, excel data columns

About the Employer:
( 13 reviews ) Millis, United States

Project ID: #583813

Awarded to:

tomj

See PM for details.

$30 USD in 1 day
(1 Review)
1.0