Fill in a Spreadsheet with Data

Completed Posted Nov 25, 2015 Paid on delivery
Completed Paid on delivery

We have a spreadsheet with a two columns: client suburb, and invoice total. We would like the information to be reformatted and compiled in a new spreadsheet so that there are 3 columns: Client suburb, total revenue per suburb, and total number of jobs per suburb.

So, instead of:

Client Suburb Invoice Total Ex

ABBOTSBURY $45.00

ABBOTSBURY $324.00

ABBOTSBURY $242.22

ABBOTSBURY $45.00

ABBOTSBURY $950.00

ABBOTSBURY $318.11

ABBOTSBURY -$318.11

ABBOTSBURY $0.00

ABBOTSBURY $0.00

ABBOTSBURY $220.00

ABBOTSBURY $45.00

ABBOTSBURY $227.27

It will be:

Client Suburb Total Revenue Per Suburb Total Number of Jobs Per Suburb

ABBOTSBURY $2,098.49 12

Data Entry Excel

Project ID: #8972659

About the project

24 proposals Remote project Active Nov 25, 2015

Awarded to:

kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliv More

$14 AUD in 1 day
(74 Reviews)
5.9

24 freelancers are bidding on average $24 for this job

opu00

Greetings!!! Can we discuss details about your project so that I can submit some sample entries and it will help you to understand our Quality of work and It will also help me to give you fair price and exact time fram More

$54 AUD in 1 day
(653 Reviews)
8.3
muzammil21

A proposal has not yet been provided

$34 AUD in 1 day
(81 Reviews)
6.6
ponchovw

A proposal has not yet been provided

$30 AUD in 1 day
(54 Reviews)
4.7
magentapowa

Hello I have it ready. Whenever you want I can send it to you. Don't hesitate to contact me. Michael

$10 AUD in 1 day
(31 Reviews)
4.3
npoli2712

Hello, I've read your description carefully and I find your project suits me. I'll work for $20 (plus $5 freelancer fee), within 1 day. I have a lot of free time now. Please tell me in detail over the chat box. More

$25 AUD in 1 day
(14 Reviews)
3.9
achievers12

Hi, I would like to use my past experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interest More

$25 AUD in 1 day
(3 Reviews)
2.1
lapointecrystal

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
davidvy

Looks like peace of cake. I am new freelancer, I will be very thankful for every chance. Thank you for reading this.

$20 AUD in 1 day
(0 Reviews)
0.0
harsh2020

Native fluency in English, IELTS score of 7.5/9.0. International research-level master's degree with more than seven years of professional experience gained from various multi-national companies.

$25 AUD in 1 day
(0 Reviews)
0.0
norainihussin

I've had 10 years of work experience and working with excel started in Primary School. As a social media manager, I use excel every day to collate data or schedule posts. The task that is needed to complete requires me More

$20 AUD in 1 day
(0 Reviews)
0.0
melkr125

I can do this for you very quickly. Please contact me and I will show you a screenshot of what I have done. I can also add in formulas for you if you need them. I can make you a pivottable too or have a chart that auto More

$20 AUD in 1 day
(0 Reviews)
0.0
receiptsdirect

I have lots of experience in data entry with out making any errors.I have a advanced knowledge of spread sheet calculation which helps to make the job better

$25 AUD in 1 day
(0 Reviews)
0.0
gkapas

A proposal has not yet been provided

$17 AUD in 1 day
(0 Reviews)
0.0
Grecodesign

it's a real simple stuff to do. I can do it in a couple of minutes. I can also (if you want) insert filters so you can organize the list with a simple click in base of what kind of data you need first.

$20 AUD in 1 day
(0 Reviews)
0.0
joseac2001

Hi, I have a lot of experience working with excel and I can guarantee you a great work, you can check how the project is going as many times as you like. Thanks for considering, have a nice day.

$20 AUD in 1 day
(0 Reviews)
0.0
bwjones63

I know exactly what you need, and I've created many types of these tables. I can have it completed for you within minutes.

$22 AUD in 1 day
(0 Reviews)
0.0
jackfwilliams98

I ensure FAST and ACCURATE data entry available to you within 24 hours. Please feel free to contact me. Cheers, Jack

$20 AUD in 1 day
(0 Reviews)
0.0
Arkuda

The experience that I have will get the job done the right way efficiently and effectively. 5 years experience of data processing and mining for supply chain department also 2 years experience as a Business Solutions More

$25 AUD in 1 day
(0 Reviews)
0.0
sushmithadshiny

I work for a reputed company as client service executive. I have hand on experience in formatting and excel. Please assign me the project and I assure you to complete it efficiently and accurately.

$30 AUD in 1 day
(0 Reviews)
0.0
cesbardon

I am very accurate in data entry jobs. I have a lot of experience in using microsoft excel. I can finish any work assign to me as fast as I can.

$15 AUD in 1 day
(0 Reviews)
0.0