Find Jobs
Hire Freelancers

Convert Excel Data from Matrix to List

$10-30 AUD

Completed
Posted almost 6 years ago

$10-30 AUD

Paid on delivery
I have 22 excel sheets each with tabs from April 2017 to January 2018 with data in a Matrix arrangement: Tab - Month Column - Day Row - Hour Column/Row - Value I need the data for all 22 excel sheets rearranged to be in the following format: Column 1 | Column 2 dd/mm/yyyy hh:mm:ss | value One of the excel documents is attached for reference, as a worked example: Tab: April Time: 1:00:00 PM Date: 5 Value: 40.8 Should be represented as: Column 1 | Column 2 5/04/2017 13:00:00 | 40.8 Quotes are needed to do reformating of all 22 excel sheets.
Project ID: 17159697

About the project

47 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
Hello, I will convert your excel data from matrix to list. I'm willing to give sample on April 2017 for your review and comment. Best regards, Hoang
$30 AUD in 1 day
5.0 (131 reviews)
6.8
6.8
47 freelancers are bidding on average $35 AUD for this job
User Avatar
Greetings! I have reviewed the data format in attached file and tried performing the conversion process for sample data. I can implement the conversion for all the files. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on Excel every month. If awarded, I guarantee defect free delivery. Have a Great Day! Srinivasan
$100 AUD in 3 days
5.0 (156 reviews)
6.6
6.6
User Avatar
Understood, need to reformat the data as per the instructions provided. Will get it done with complete attention to details.
$30 AUD in 1 day
4.9 (100 reviews)
6.5
6.5
User Avatar
Hey there!! I am ready to provide you the great service from the right away. And I will be glad to work with you for long term way. I've well experienced team. I will assure you that you will get a quality work according to your instructions. I am an expert in the following Data Processing, Excel, Software Architecture, Software Development, Software Testing and etc. Regards, George
$70 AUD in 1 day
4.9 (10 reviews)
4.9
4.9
User Avatar
HI, MYSELF BHARAT. I AM AN EXCEL EXPERT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO EXPERIENCE IN SORTING DATA, CATEGORIZING ITEMS, REMOVING DUPLICATES, WORKING WITH FUNCTIONS OR FORMULAS, REARRANGING AS PER THE REQUIREMENT, COMPARING SHEETS FOR UNIQUE DATA, AMALGAMATION OF TWO SPREDSHEETS ETC. I CAN WORK ON ANY KIND OF EXCEL WORK. I HAVE THE ABILITY TO FOCUS ON THE TASKS GIVEN AND ALSO POSSESS EXCELLENT ENGLISH COMMUNICATION SKILLS. I LOOK FORWARD TO WORKING WITH YOU SOON.
$40 AUD in 2 days
4.9 (14 reviews)
4.1
4.1
User Avatar
I am proficient in using Microsoft Office Applications and Google Spread Sheets. I am a General VA also and a quick learner individual.
$30 AUD in 1 day
4.8 (8 reviews)
3.6
3.6
User Avatar
Hello, I’m pleased to send you my proposal for your project. As an experienced auditor, I have expertise in compiling large amounts of data from multiple sources into Excel, so a main part of my job is cleaning, formatting and consolidating data sets, using different formulas to achieve faster and reliable results. As you can see in my profile, I have experience in a variety of tasks. Now I'm working on becoming a freelancer, looking forward to engaging in new projects. Please feel free to contact me anytime. Thank you, Regards, Angélica
$30 AUD in 1 day
5.0 (1 review)
3.0
3.0
User Avatar
I've reviewed the Excel sheet you have provided and can guarantee getting the job done in a day. I am willing to begin as soon as you give me the go ahead. Patiently awaiting your reply.
$25 AUD in 1 day
5.0 (3 reviews)
2.5
2.5
User Avatar
Hai this is Gajendran, I’m having good experience in Data entry work. Based on your project description I will update all the details and provide you the best data, will complete this task within time limits. I’m interested in your project, kindly give an opportunity to do the same. Thanks in advance.
$25 AUD in 1 day
5.0 (9 reviews)
2.2
2.2
User Avatar
I am very lucky to bid Relevant Skills and Experience I will do my level best and complete the task within 24 hours
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Jst trying my best .. Relevant Skills and Experience 24 hr on typing
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I went through your project details and I am absolutely interested in your project. I can comple your excel task within oneday. I am glad to say that I am excellent in computer literacy and I can handle any kind of Data Entry tasks. Experience - I am working for a government firm in my country as a management assistant for more than 2 years. I am sure that I will be able to reach your expectations at my earlieast possible. If you are intersted, get back to me with more details. Thanks.
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I have a lot of experience using excel, and can do this quickly and accurately. Thank you, Josh
$30 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time.
$23 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can say that the knowledge and skills that I have suites the this post that I am applying for. I have advance learning in using Microsoft Excel and Word and we know that these 2 are the major tools that are being used especially for creating data sheets. I also have 1 year experience on being a data encoder on a government office here in the Philippines.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! I read the job description and I am very interested with the task. Please contact me and consider my bid. Thank you.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have many experienced excel member its my believe we can resolve your each and every problem related to excel.
$25 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been a data entry specialist in a BPO Company for 7 years. Enter data from source documents into prescribed computer database, files and forms. Flexibility-wise, I was able to adjust on the changes and tasks that I was assigned to. I can do 60 words per minute and above. And I have basic knowledge of Photoshop. Which I can improve more. I am a person who easily learns, very hardworking person and willing to be trained. I want a long-term and stable job. I would like to gain new skills while utilizing my current area of expertise of procurement and employee satisfaction services within a positive team environment. Regards, Jovencio A. Eslava Jr.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will definitely fulfill your requirements.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a lot of experience in excel and understand your project. I could have this work completed in one day for you. Kind Regards, Leanne
$66 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can type text @60 wpm in English . My speed and accuracy is good. I consider typing as a challenge. I have been working as a data entry operator since 1998. I am working this work offline. I have more than hundred customer support of local market. They always choose me for accuracy and speed. I always satisfy them with my work and behaviour.
$15 AUD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Castle Hill, Australia
4.9
16
Payment method verified
Member since May 7, 2014

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.