Excel - Convert Half hourly Metering data into one column for CSV
- or -
Post a project like this2878
$$
- Posted:
- Proposals: 9
- Remote
- #1159088
- Completed
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
Data Entry | Data Scraping | Database Clean Up | Excel | Data Research | Data Mining | web research | Data Cleaning
Zagreb
6771401244165121422839155912534819634741601801228050208270
Description
Experience Level: Intermediate
General information for the business: We develop renewable energy projects
Industry: Technology
Description of excel work: I have a spreadsheet containing half hourly metering data.
In column A is dates from 1st Jan to 31st Dec.
In row A is a time representing every half hour of a day (00:30, 01:00 etc).
B2 onwards shows how many units of electricity were consumed in that half hour period.
I would like a formula that makes this into one cell reading something like 01/01/2016 00:30 ; 447
This formula should then be applied across all data in the sheet to provide one column with all data.
See attached example spreadsheets
Extra notes: Need done very quickly (before 09:30 British Summer Time)
Industry: Technology
Description of excel work: I have a spreadsheet containing half hourly metering data.
In column A is dates from 1st Jan to 31st Dec.
In row A is a time representing every half hour of a day (00:30, 01:00 etc).
B2 onwards shows how many units of electricity were consumed in that half hour period.
I would like a formula that makes this into one cell reading something like 01/01/2016 00:30 ; 447
This formula should then be applied across all data in the sheet to provide one column with all data.
See attached example spreadsheets
Extra notes: Need done very quickly (before 09:30 British Summer Time)
Chris S.
100% (2)Projects Completed
7
Freelancers worked with
7
Projects awarded
42%
Last project
20 Oct 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies