Basic Excel Macro / VB - repost

This project received 25 bids from talented freelancers with an average bid price of $28 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
Project Description

I have a spreadsheet of 3000 lines. It contains only a few columns and is very simple to understand. I've attached a very easy to understand example.

Basically I need a concatenation of all the lines which contain the same SKU.

I need the year and model columns concatenated where for all duplicate SKU, and combined into a YEAR and MODEL cell, only ONE YEAR and MODEL per SKU, and then duplicate years and models removed from that new concatenated cell. With the proper macro this should not take more than an hour, I have two macros that can do this, but I have never experimented with VBA inside of Excel, and would rather pay to have it done properly, and in a quick amount of time.

This is time sensitive, and is not a difficult project. Should be easy money.

Do to the amount of copy and paste spam on project bids, please include today's date in your bid. Thank you.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online