Excel spreadsheet data cleanup
- or -
Post a project like this1065
£10(approx. $13)
- Posted:
- Proposals: 7
- Remote
- #3265294
- Awarded
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |
San Jose
1788290117624317115862367328253814634314165863205
Description
Experience Level: Entry
Estimated project duration: 1 hour
I have an excel spreadsheet where multiple sustainability issues (e.g. "Co2 emissions", "air pollution", etc.) have been copied together in single cells (see the cells in yellow in the attached document - column D). I would like to have one cell per sustainability issue (like the cells in green - same column D).
For each row that has a yellow cell, duplicate the entire row as many times as needed, and split the yellow cell contents over multiple rows so that we get one issue per row.
For each row that has a yellow cell, duplicate the entire row as many times as needed, and split the yellow cell contents over multiple rows so that we get one issue per row.
Jeremie G.
100% (22)Projects Completed
27
Freelancers worked with
23
Projects awarded
46%
Last project
19 Oct 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There is no attachment can you sent it to me for review please?
981970
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