Completed

Convert Excel Data from Matrix to List

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.

Skills: Data Processing, Excel

See more: convert cross table to list excel, convert table to list in excel, excel convert table to single column, transform matrix excel, excel convert 3 columns to matrix, excel convert array to cells, how to convert multiple columns to single column in excel, excel convert matrix to single column, I would like to convert data in a pdf into excel., i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, excel data classification list, excel data exhibitor list, excel data validation list picture, convert excel data sql, convert excel data microsoft apple

About the Employer:
( 15 reviews ) Castle Hill, Australia

Project ID: #17159697

Awarded to:

hdlong66

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
(123 Reviews)
6.7

48 freelancers are bidding on average $37 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA Programmer on freelancer.com and have been featured by the freelancer community ( More

$100 AUD in 0 days
(567 Reviews)
8.2
KulfiSoftwares

I love excel and can quickly and accurately format the 22 files as requested. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work. https://freelancer.com/u/kulfiSoftwares ht More

$250 AUD in 3 days
(232 Reviews)
7.3
ksriniravi

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 excl More

$100 AUD in 3 days
(140 Reviews)
6.5
ReliableMate

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
(91 Reviews)
6.4
$20 AUD in 1 day
(123 Reviews)
5.9
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. This quote is for all the excel sheets. Kindly send me a message to discuss further. Thanks, Asad Khan

$166 AUD in 2 days
(44 Reviews)
5.2
$25 AUD in 1 day
(37 Reviews)
5.2
jinigo23

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 accordi More

$70 AUD in 1 day
(10 Reviews)
5.1
BHARATBEURA

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 TH More

$40 AUD in 2 days
(13 Reviews)
4.1
monettemejo27

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
(6 Reviews)
3.3
$25 AUD in 1 day
(4 Reviews)
3.7
$25 AUD in 1 day
(3 Reviews)
2.6
angelicadosreis

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, fo More

$30 AUD in 1 day
(1 Review)
2.4
TrippleF

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
(3 Reviews)
2.5
Gajacrafty

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 inter More

$25 AUD in 1 day
(6 Reviews)
1.9
Lakshyasai

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 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
lcowleyspence

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 Reviews)
0.0
sanjeevmth701

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 cu More

$15 AUD in 0 days
(0 Reviews)
0.0
jaya061188

I have 4 years of experience in data e Entry which makes me perfectly suitablefor this job and I work dedicatedly with honest Relevant Skills and Experience I'm looking for long term Association and Ready to negotiat More

$10 AUD in 1 day
(0 Reviews)
0.0