Analyze some Data

Hi There!

I have 50+ spreadsheets containing similar information in wildly different formats that need to be consolidated into one simplified database. The data compares around 50 different distributor's sales by product, by month - currently with each distributor on a different spreadsheet. I'd like to get it to the point where all the data is in one centralized database so that we can see trends over time by product across all distributors or search the data with ease.

Skills: Data Processing, Excel

See more: 12 month spreadsheet, data trends excel, historical sales data analyze, month month excel sales spreadsheet, excel spreadsheet containing sales data, time sales data tradestation spreadsheet, sales data excel spreadsheet, product need distributors, information different spreadsheets, exporting data excel spreadsheet quality center, find information complete various entries data fields spreadsheet, database spreadsheet similar, paste data excel spreadsheet, database analyze, data processing spreadsheet, php mysql data google spreadsheet

About the Employer:
( 1 review ) Newberg, United States

Project ID: #6820892

Awarded to:


Dear Project Manager, Here is my plan of attack: 1. Identify how many "Wildly different" formats actually exist. (Do you happen to have a count?) 2. Establish from you the standard format to which each format mu More

$250 USD in 15 days
(11 Reviews)

15 freelancers are bidding on average $149 for this job


so you have 50+ sheets, with format similar to attached, and you want all data to be put into one excel sheet, yes possible thx

$200 USD in 3 days
(295 Reviews)

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E More

$100 USD in 0 days
(253 Reviews)

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I mainly work on income statements, pricing models, conjoint surveys, business analysis etc. Prior that I have completed MBA and bachelors in Enginee More

$188 USD in 3 days
(29 Reviews)

hi sir, i understand you want to have a master file which contains all of the 50 files unique information, let me help you with, i am good at excel and formulas. will put all the unique info from all the 50 files and More

$64 USD in 3 days
(42 Reviews)

Hi, I have checked your sample excel..yes it is not in format to give you true can share all sheets...I can make them standard and also can help produce great graphs, summary tables to give you summarized More

$200 USD in 3 days
(12 Reviews)

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee More

$150 USD in 3 days
(6 Reviews)

Hi, We are avgroup of analysts workjng in quantitative analytics and data processing for last 10 years. We can do the job well on time with highest quality. Kindly let us know more about the different format inputs yo More

$95 USD in 3 days
(10 Reviews)

Hi, I'm Excel VBA expert and will develop code to consolidates data from different sheets into one Please share excel format as a sample thanks

$155 USD in 3 days
(9 Reviews)

will do it for very low budget..............................................................................................................................Pm me for further discussion

$66 USD in 3 days
(7 Reviews)

Hello, if you want I can introduce the work done (I need a few files), without any obligation to choose my offer. Thank you very much Jan Krzyzak

$200 USD in 7 days
(3 Reviews)

Hello sir, I understand your work... I will do this work perfectly on time... Please give me this opportunity to complete this project..... I hope you like to discuss with me... Thanks

$83 USD in 2 days
(4 Reviews)

Dear Importer, My name is Katerina and I will be happy to assist you with making the stock depletion database for all 50+ distributors. I took a look at the file and I am confident I can manage well. There is not More

$233 USD in 3 days
(0 Reviews)

Good at analyzing and excel, will be able to do quality job on time. I have lot of spare time. hence will be able to complete quality work on time.

$94 USD in 3 days
(0 Reviews)

The project objective is to create centralized database which could be used to provide required information. My bid is a reasonable price and for reasonable time. I will be ready to do this job and I need some detai More

$150 USD in 5 days
(0 Reviews)