Closed

Excel spreadsheet data manipulation - repost

This project was awarded to florianfilat for $2 USD / hour.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$2 - $8 USD / hour
Total Bids
37
Project Description

We have a spreadsheet with a large set of sales data in a single worksheet. We sell to a number of organisations each of whom has a number of branches. There is one record for every branch with a number of fields - perhaps 30 or more fields. So the detail (simplified) looks like this:

Company Branch Sales this year Sales last year ...
A 1 124 144
A 2 653 445
A 3 0 25
B 1 25 12
B 2 0 0
.
etc
.
So, to confirm, this is all one worksheet. There will be maybe 10-15 companies and all together about 4000 records.

We want to split the data up so we have 2 extra tabs in the workbook for every unique company in the list(ie A,B...). The first tab for each company contains the records of that companies branches with non-zero sales this year, ie in the example

A 1 124 144
A 2 653 445

Tab name A-Active

and the second tab contains the records of the branches that had zero sales this year, ie

A 3 0 25

Tab name A-Dormant.

Similarly for company B - we get B-active and B- dormant, which are the records for the trading and non trading branches of company B.

I am hoping there is some really simple solution using filters. The company names could probably be "hard wired" since there are only about 15, a more complex solution would look for unique values.

The new tabs should ideally contain simple excel data with the headers (1st row) repeated.

I have a sample full size data set with real data. enclosed show the principle only on a tiny scale.

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