Tamamlanmış

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.

Beceriler: Veri İşleme, Excel

Daha fazlasını gör: 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

İşveren Hakkında:
( 15 değerlendirme ) Castle Hill, Australia

Proje NO: #17159697

Seçilen:

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% AUD
(123 Değerlendirme)
6.7

Bu iş için 49 freelancer ortalamada $37 teklif veriyor

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 ( Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(566 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(230 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(140 Değerlendirme)
6.5
ReliableMate

Understood, need to reformat the data as per the instructions provided. Will get it done with complete attention to details.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(90 Değerlendirme)
6.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(123 Değerlendirme)
5.8
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

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(44 Değerlendirme)
5.2
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(36 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(10 Değerlendirme)
4.9
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(6 Değerlendirme)
3.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(4 Değerlendirme)
3.7
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(3 Değerlendirme)
2.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(3 Değerlendirme)
2.6
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(6 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0