Em Andamento

Merge Data in Excel

This project consists of merging the data on three excel spreadsheets into one sheet. I have data for many different variables (the columns) covering many similar countries spread across three sheets in Excel. I would like the observations for each of these variables aligned by country and by year so that the columns represent the country, the year, and each variable. I do not have 100% overlap between the countries represented and there is missing data for some variables on some years. Nevertheless, the rows should cover 1970-2012 for each country and each variable- including blank spaces left when there is no data for those countries/those years.

I have completed the operations for the first country, Afghanistan, on sheet 4 as a model to follow. Specifically, I merged the data from sheets 1-3. Please let me know if you have any questions- I look forward to receiving your bids.

Mike

Habilidades: Processamento de Dados, Excel

Ver mais: blank model sheet, merge data, missing columns data, excel merge spread sheet, excel sheets merge, year model data, excel project model, year model excel, missing entry excel, follow excel, data merge excel, excel merge sheets, operations excel, excel sheets data project, entry data sheet excel, excel sheet data merge, excel 2012 merge, merge data excel sheet, spread merge, excel spreadsheet merge data, excel data operations, excel data operations macro, merging excel spreadsheets, merging spreadsheets, project merge

Acerca do Empregador:
( 5 comentários ) Boise, United States

ID do Projeto: #6804061

Premiar a:

gokulanand

Hello, I can get you a simple VBA script to do this task. I hope the columns across all the sheets are same, if so I can get this done with in the next 6 to 12 hours time. Let me know if you are interested. Thank Mais

$30 USD em 1 dia
(17 Avaliações)
4.4

13 freelancers estão ofertando em média $34 para este trabalho

Teloquence

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E Mais

$24 USD in 0 dias
(229 Comentários)
7.0
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mais

$44 USD in 0 dias
(76 Comentários)
5.9
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I can complete the job within some hours with advanced Excel fun Mais

$30 USD em 1 dia
(55 Comentários)
5.7
Ibrahim185

sir, I have read the job description very carefully,I am highly interested and dedicated to do this task. let's discuss and start. i am awaiting for your positive reply. thanks

$100 USD in 3 dias
(124 Comentários)
5.4
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$30 USD em 1 dia
(66 Comentários)
5.3
Hurnara362

Hello Sir, I m interested in this job.Give me a chance please.Thanks..............................................

$34 USD in 3 dias
(51 Comentários)
4.9
keerthaninfo

A proposal has not yet been provided

$25 USD em 1 dia
(26 Comentários)
4.7
snuwanlk

Hi Mike, I can get the job done quickly. I am using office 2013. Waiting for your update. Regards, Richard

$20 USD em 1 dia
(4 Comentários)
4.5
vsprybhanu

Hi, Experienced VBA, VB6 and VB.Net Programmer. Expertise in Data Entry, Data Processing, Excel and Programming. Read and understood your project description. I've excellent knowledge of moving data arou Mais

$30 USD em 1 dia
(25 Comentários)
4.0
soikaushik2013

Hello. I'm willing to work in this project. I will make a simple program to merge data from 3 sheets to generate output sheet. Waiting for your reply. Thanks. Regards.

$24 USD in 0 dias
(10 Comentários)
3.2
leelaaswanth

................................................................................................................................................................

$25 USD em 1 dia
(8 Comentários)
2.8
RAHUL007A

I can assure about work being completed as per the given details and in specified time with correct information, please do pm me to discuss about the details , awaiting your reply.

$25 USD em 1 dia
(4 Comentários)
2.2
masdilhan222

HI I have ability to complete this project as you wish.just let me complete this and payment can done end of the project.

$25 USD in 2 dias
(0 Comentários)
0.0