Käynnissä

Program To Combine 2 Excel Sheets

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.

Spreadsheet 1

Identifier column1 column2 column3

aks1223 apple pear dog

335679-1 red green hair

ww998 hello blue hat

qurt555 55 hair door

Spreadsheet 2

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.

Taidot: Excel, PHP

Näytä lisää: excel combine rows, simple spreadsheet examples, 33333, spreadsheet 2, snakes, sheets, dog hat, cows, combine, combine excel, combine order, excel combine, excel rows lines, combine rows excel, program final, combine program, separate rows column, apple spreadsheet, spreadsheets combine, apple excel spreadsheet, apple spreadsheet excel, output program excel, php excel output, separate excel, php file combine

Tietoa työnantajasta:
( 13 arvostelua ) atlanta, United States

Projektin tunnus: #4931571

Myönnetty käyttäjälle:

angan

I can give the solution within 1 hour

30 $ USD 0 päivässä
(10 arvostelua)
2.5

16 freelancers are bidding on average $75 for this job

yunuscse

I can do it for you.

100 $ USD 1 päivässä
(96 arvostelua)
6.5
Teloquence

Consider it done. Check your PM for my bid details.

80 $ USD 0 päivässä
(114 arvostelua)
6.1
binaryromel

##### Excel expert here! Please check PM. #####

30 $ USD 0 päivässä
(46 arvostelua)
5.2
maverick44000

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

130 $ USD 1 päivässä
(10 arvostelua)
4.6
prakashmondal

hi, I can develop a script to do this task. Please see PM.

60 $ USD 1 päivässä
(29 arvostelua)
4.4
hemsingh1

Hi, WP Expert here. Ready to Start. Please check my PMB. Thanks

55 $ USD 0 päivässä
(7 arvostelua)
3.1
saadrashad

i am experience in excel. I am ready to do the project please need a little clarification for that check PMB.

33 $ USD 0 päivässä
(5 arvostelua)
2.8
kamaljeetdd

Hi, ={{{Quality Assurance and Client Satisfaction}}}= Ready to Start now.... Thanks & Regards, Kamal

100 $ USD 3 päivässä
(4 arvostelua)
1.7
kartikprmr

Hi, I can do this job. 100% satisfaction guaranteed.

155 $ USD 3 päivässä
(1 arvostelu)
0.0
sriraaj2013

may i do this project.

100 $ USD 3 päivässä
(0 arvostelua)
0.0
Eudge

I can do it quickly

100 $ USD 1 päivässä
(0 arvostelua)
0.0
prohappy

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

70 $ USD 3 päivässä
(0 arvostelua)
0.0
amieshaiful

please check details at your pmb

55 $ USD 2 päivässä
(0 arvostelua)
0.0
kalupaika

Have worked with advanced excel. It can be done using macros

66 $ USD 5 päivässä
(0 arvostelua)
0.0
theps

Please send me your files

35 $ USD 1 päivässä
(0 arvostelua)
0.0