I need a program that can take two separate excel spreadsheet files, and combine them into a single file based on a common identifying number. In both sheets, the first column would have the identifying number. The program should then combine these sheets, so that the rows on both sheets line up in a single long line in the third output sheet. Below I have a very simple example. I will need the final solution to be scalable to spreadsheets of any size if possible.
I would like this program to run entirely on my computer.
Identifier column1 column2 column3
aks1223 apple pear dog
335679-1 red green hair
ww998 hello blue hat
qurt555 55 hair door
Identifier column1 column2
335679-1 camels cows
ww998 snakes hello
qurt555 bottles cents
aks1223 33333 words
Spreadsheet 3 - Output (combined sheets)
Identifier column1-sp1 column2-sp1 column3-sp1 column1-sp2 column2-sp2
aks1223 apple pear dog 33333 words
335679-1 red green hair camels cows
ww998 hello blue hat snakes hello
qurt555 55 hair door bottles cents
As you can see the first to spreadsheets are just outputted into a third that lines up all the rows according to that same identifier. I can send anyone who requests examples of the first two spreadsheets I will be looking to combine, however I'd like the final program to be scalable so I could use it on any two spreadsheets of any size as long as the first column on both has that same identifying number. The order of the records also should not matter.
16 freelancers are bidding on average $75 for this job
Hi Pebblez. Being highly proficient in Excel designs, I shall be able to deliver the combining program in a day. Lets kick off and get started. Regards
Hello Sirs, I have more than 10 years experience in programming. So, I can deliver you the best possible solution. Please send me excel files. Best regards