Find Jobs
Hire Freelancers

Ordering Data in Excel

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I have an excel file where data goes from A1 to EZ7000. After the first 35 rows most are empty cells, but there could be some isolated value in some rows in far cells. Most codes are duplicated. My data is in the excel file as "Data" and I need to order it as shown in "Sample Output"
Project ID: 15955398

About the project

34 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have seen your attached file, I need only 30-45 mins to complete this task. I am expert in EXCEL MACRO.
$15 USD in 0 day
5.0 (73 reviews)
5.7
5.7
34 freelancers are bidding on average $22 USD for this job
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I can create you a macro that will loop through all rows and generate the exactly the same output as shown in "Sample Output" sheet. Anyway, i've completed hundreds of excel projects without a single problem. Thanks, Milan
$20 USD in 0 day
5.0 (552 reviews)
7.1
7.1
User Avatar
Hi! I'm interested on working on your project. I'm really fast and organized. I also have experience working on excel, as you can check on my profile page. I'm ready to start working right away and deliver the final file asap. I'm confident I can make an excellent job. I hope you give me the opportunity to work with you. Regards.
$30 USD in 1 day
5.0 (122 reviews)
6.9
6.9
User Avatar
Hey There, I can do this in couple of hours. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman
$30 USD in 1 day
4.9 (176 reviews)
6.5
6.5
User Avatar
As I understand you require that each row is transposed to a final one column with duplicate codes removed, correct? But on the sample you want codes that are '0' to be retained as blank cells?
$30 USD in 1 day
4.9 (207 reviews)
6.7
6.7
User Avatar
Hello there It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in VB, VBA, C++, C#, OPPs, HTML5, CSS3, JS, AJAX, JQYERY, React.js, ANGULAR.JS, BACKBONE.JS, BOOTSTRAP, PHP,Wordpress, ASP.NET, MVC, Excel VBA Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great results.I have fast internet connection at home, have my own pc to use anytime and have own space to work. I can work fulltime and will focus to this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible..
$20 USD in 1 day
5.0 (90 reviews)
6.4
6.4
User Avatar
Dear Sir, I have read your job details and see your attach file (data & Sample file). I understand your project sir. I must complete your job. I will provide you best work then other . Please allow me this project. I am ready to start right now. Thank You. Regards, Moumita
$25 USD in 2 days
5.0 (134 reviews)
6.1
6.1
User Avatar
Hi, I have gone through your project details and can help you in getting it done quickly and efficiently. I have worked on several excel related projects and maintaining data in it and sorting etc. based on which I assure you of optimum solution. Waiting for your response for detailed discussion. Thanks. I can help you with macro that will take sheet as input and provide output as required.
$25 USD in 1 day
4.8 (112 reviews)
5.9
5.9
User Avatar
Hi, I am interested in performing this task. Saw the file attached and understood the requirement. Can get this completed if you are interested. Looking forward to hear from you. Best Regards, Akila.K
$22 USD in 1 day
5.0 (49 reviews)
5.6
5.6
User Avatar
Hi.. I am expert in data entry work. I have seen your attached file and read the project description. i can do it.. i know very well excel . and hope i can provide you with quick time. my work rate will be 30$ Saidul
$30 USD in 1 day
5.0 (51 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
4.9 (25 reviews)
5.2
5.2
User Avatar
Hi, Kindly review my profile to know more about my skills and experience required for this project. Regards Awais Jehangir
$25 USD in 1 day
4.6 (37 reviews)
5.3
5.3
User Avatar
hello it is with great pleasure that I will do this work, I have more than 15 years of experience in data processing I am a very motivated computer engineer, Regards
$25 USD in 1 day
4.8 (7 reviews)
4.8
4.8
User Avatar
Hello i invite you to discuss more over chat to clarify the ordering work you need I am a highly skilled data processor Thank you
$19 USD in 1 day
4.7 (28 reviews)
5.0
5.0
User Avatar
Hi.. I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you to but I can give you an assurance of a good job. Thanks.
$25 USD in 1 day
4.9 (21 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (19 reviews)
4.4
4.4
User Avatar
hi we got your sample data file we can do this project if you can discuss more about this please send pm so that we can move ahead thanks
$10 USD in 1 day
5.0 (9 reviews)
4.4
4.4
User Avatar
Hi, I am good in xls tasks. I am fast and precise, so let me know more about it, and I can help you. Br, Anna
$21 USD in 2 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.
$20 USD in 0 day
4.7 (15 reviews)
3.1
3.1
User Avatar
Hello, your project is very interesting and fascinating to me I would like to participate in it. I have knowledge adding information to a database and is the kind of work of my interest. if you can make me a test and realize about my way to work and see results on the first day. Regards,
$15 USD in 10 days
4.0 (3 reviews)
2.6
2.6
User Avatar
DEAR SIR / MAM , HI I AM VINNY FROM SPAIN . AS PER YOUR JOB WE HAVE THREE PEOPLE TEAM HERE IN OUR OFFICE WE ALL HAVE MORE THAN 10 YEARS EXPERIENCE M .OFFICE .
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PORTUGAL
Lisboa, Portugal
5.0
4
Payment method verified
Member since Jan 23, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.