Excel Format Changed

V teku Objavljeno Oct 9, 2013 Plačilo ob prevzemu

$10-30 AUD

Plačilo ob prevzemu

V teku Plačilo ob prevzemu

Hi,

I have an excel sheet which has over 2500 columns. Evidently the data is not manageable as it also needs to be used in an sql database.

The excel file is about 170mb.... will dropbox to winning bidder.

Using whatever means or language you like, I need to have the format changed.

At the moment the format is as follows

postcode, year, field1, field2, field3, field4 ..... field2500

I need it changed to

postcode, year, fieldname, fielddata

this would leave mean we plenty more rows, but a lot less columns.

I also need it done in the next few hours - please state time needed.

Thanks

C programiranje C# programiranje Visual Basic

ID projekta: #5010317

Več o projektu

13 predlogov Oddaljen projekt Aktiven Oct 9, 2013

Želiš zaslužiti nekaj denarja?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Bodi plačan/a za svoje delo
Oriši svojo ponudbo
Vpis in prijave na dela so brezplačni

Dodeljeno:

Profilna slika notenuet
notenuet

Hi there, I can do this. Please give the file, so i can start from now. And It will be done in 4 hour. thanks bimo

$30 AUD v 1 dnevu
(4 mnenj)
5.0

13 freelancerjev ponuja v povprečju za $36 na tem delu

Profilna slika paris2785
paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems. I will have it ready in 5 hours

$29 AUD v 1 dnevu
(93 ocen)
6.6
Profilna slika ahetel
ahetel

Hello, I can provide the database as SQL Server 2008 R2 backup. The second option is to give you insert scripts to avoid compatibility issues when restoring backups. Best regards, Andrei Hetel

$35 AUD v 1 dnevu
(22 ocen)
4.7
Profilna slika Alexnick
Alexnick

Dear Sir/Madam What is the format of your file? Is it a proprietary excel file (xls, xlsx) or csv? I can try to perform the changes you need through MATLAB, which can open excel files and should be able to handle su Več

$30 AUD v 1 dnevu
(17 ocen)
4.7
Profilna slika adim
adim

Hi there, I can start immediately and hopefully be ready in 1-2 hours. Would write some VBA code to do the job. Regards, Adrian

$30 AUD v 1 dnevu
(15 ocen)
4.5
Profilna slika sswijaya
sswijaya

Hi, let me help you with this. I can build an excel macro VBA to transpose data into rows. I'm estimating this will take about 3 hours. Looking forward for your quick reply. Regards, Susanto.

$30 AUD v 1 dnevu
(9 ocen)
3.4
Profilna slika hemantjani
hemantjani

we are ready to do this and start on it asap can done in day may be less need few more detail so PM me and we get started. consultant with an expert team of 10 that can handle any challenge based on programming, we Več

$30 AUD v 1 dnevu
(3 ocen)
2.0
Profilna slika ud2
ud2

ready to do this asap...................................................................................................................

$30 AUD v 2 dneh
(0 ocen)
2.0
Profilna slika jlchance
jlchance

If you offer me this job, I will import the data into a SQL database and then write a query to modify it to produce the output you need. It will take about 4 hours. If your budget is truly $30, then I really can't help Več

$111 AUD v 1 dnevu
(0 ocen)
0.0
Objavi podoben projekt