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.

Taidot: tietojenkäsittely, Excel

Näytä lisää: 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, 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, data entry, virtual assistant, data processing, excel, word, database administration, microsoft excel, excel data exhibitor list, excel data validation list picture

Tietoa työnantajasta:
( 15 arvostelua ) Castle Hill, Australia

Projektin tunnus: #17159697

Myönnetty käyttäjälle:

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 1 päivässä
(123 Arvostelua)
6.7

48 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 ( Lisää

$100 AUD 0 päivässä
(567 arvostelua)
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 Lisää

$250 AUD 3 päivässä
(232 arvostelua)
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 Lisää

$100 AUD 3 päivässä
(140 arvostelua)
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 1 päivässä
(91 arvostelua)
6.4
$20 AUD 1 päivässä
(123 arvostelua)
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 2 päivässä
(44 arvostelua)
5.2
$25 AUD 1 päivässä
(37 arvostelua)
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 Lisää

$70 AUD 1 päivässä
(10 arvostelua)
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 Lisää

$40 AUD 2 päivässä
(13 arvostelua)
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 1 päivässä
(6 arvostelua)
3.3
$25 AUD 1 päivässä
(4 arvostelua)
3.7
$25 AUD 1 päivässä
(3 arvostelua)
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 Lisää

$30 AUD 1 päivässä
(1 arvostelu)
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 1 päivässä
(3 arvostelua)
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 Lisää

$25 AUD 1 päivässä
(6 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
$25 AUD 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 Lisää

$15 AUD 0 päivässä
(0 arvostelua)
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 Lisää

$10 AUD 1 päivässä
(0 arvostelua)
0.0