Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Clean up 2 spreadsheets with dirty data

    3342
    £20(approx. $24)
    • Posted: 9 years ago
    • Proposals: 6
    • Remote
    • #235424
    • Archived
    Bjorn C.
    Bjorn C.
    Financial analyst / Finance Manager
    United Kingdom London
    Sumit M.
    Sumit M.
    Managing Director - ECorporate Web Services Ltd
    Top Endorsed
    United Kingdom London
    Ngoni S.
    Ngoni S.
    Commercial Accountant/Management Accountant
    United Kingdom Leeds
    Aruna S.
    Aruna S.
    PHP | MYSQL | Magento | Joomla | Wordpress | Responsive | Jquery | HTML | CSS | Javascript
    Top Endorsed
    India Kanpur
    Harold C.
    Harold C.
    Quantitative Software Developer
    United Kingdom London
    Ika P.
    Ika P.
    held a tiltle of environmental engineering from University of Indonesia, work as rating analyst in Non Goverment Organization
    Indonesia Jakarta
    412453104040251965287946353765203692
    Bjorn C.Sumit M.Ngoni S.Aruna S.Harold C. + 1 other have already sent a proposal.
    • 0
    • 0

    Description

    Experience Level: Entry
    This task will be fairly straightforward for someone with Microsoft Excel skills and an eye for detail. I expect it will take no more than an hour or two. It would be helpful if it could be completed by Fri 5th Apr.

    The task involves 2 Excel spreadsheets containing a number of columns, 3 of which are of interest, as follows:

    Product
    Distributor
    Manufacturer

    The other columns contain various financial information (I will need to remove this before sending due to confidentiality) and the spreadsheets contain around 9,000 rows in total.

    There are around 900 products in total, and each product, distributor and manufacturer appears multiple times in the data. The problem is that due to the fact no data validation had been put in place, each product, distributor and manufacturer may have a number of different spellings or abbreviations. For example:

    AB Johnson
    AB Johsnon
    ABJohnson
    AB Johnson Ltd.

    The task is to rename all the different spellings and abbreviations so that every time a certain Product, Distributor or Manufacturer appears, it is always spelled in exactly the same way. This should be done without deleting, adding or changing the order of any of the rows in the spreadsheet.

    You might need to contact me for clarification for example if you are unsure whether some of the different spellings are the same supplier or a different one with a similar name. (For example you might need to check whether "K. Ford" and "Ford Media" are the same company or a different one).

    The task could be made easer by exporting the data to Microsoft Access, perform cleanup, and then dropping the clean data back into the original sheet.
    Stefan K.
    Stefan K.
    100% (2)
    Projects Completed
    2
    Freelancers worked with
    2
    Projects awarded
    75%
    Last project
    20 Oct 2018
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    3342
    £20(approx. $24)
    Stefan K.
    Stefan K.
    100% (2)
    Projects Completed
    2
    Freelancers worked with
    2
    Projects awarded
    75%
    Last project
    20 Oct 2018
    United Kingdom

    Related project Searches


    data cleansing microsoft excel analysis spreadsheets

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2022 People Per Hour Ltd
    We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy