Suoritettu

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

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

Projektin tunnus: #4931571

Myönnetty käyttäjälle:

scsBiswas

I can give the solution within 1 hour

$30 USD 0 päivässä
(14 Arvostelua)
3.7

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Teloquence

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

$80 USD 0 päivässä
(328 arvostelua)
7.7
yunuscse

I can do it for you.

$100 USD 1 päivässä
(108 arvostelua)
6.7
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ä
(72 arvostelua)
6.8
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ä
(147 arvostelua)
6.1
prakashmondal

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

$60 USD 1 päivässä
(76 arvostelua)
6.0
binaryromel

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

$30 USD 0 päivässä
(90 arvostelua)
6.0
hemsingh1

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

$55 USD 0 päivässä
(65 arvostelua)
5.4
kamaljeetdd

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

$100 USD 3 päivässä
(11 arvostelua)
3.7
amieshaiful

please check details at your pmb

$55 USD 2 päivässä
(12 arvostelua)
3.7
Eudge

I can do it quickly

$100 USD 1 päivässä
(172 arvostelua)
1.7
sriraaj2013

may i do this project.

$100 USD 3 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
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
kartikprmr

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

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