Excel Format Changed
$10-30 AUD
Paid on delivery
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
Project ID: #5010317
About the project
Awarded to:
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
13 freelancers are bidding on average $36 for this job
VB, VBA and Databases expert for over a decade. Master in Information Systems. I will have it ready in 5 hours
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
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
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.
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 More
ready to do this asap...................................................................................................................
