Convert MS Excel Summary data into source raw data

$30-50 AUD

Cancelled

Posted

over 12 years ago

$30-50 AUD

Paid on delivery

I have the following MS Excel data. As you can see it is summary data, similar to a pivot table. I need to convert this into raw MS Excel table data. So when I run filters on the raw MS Excel table data, I get the pivot table results. Example: For row 3, there are 6,420 MEN who are age 20 and are married (column I). There are also 16,400 MEN who are age 20 and like Cooking (M). I need to create raw data that will include 6420 entries for MEN, age 20 who are married. Basically, I need to work backwards. I have the summary pivot table attached, however what I need your help with is working backwards to create the MS Excel raw data. You may have to develop a script/macro that can do this. Thanks, please let me know if any clarifications. Peter

Project ID: 1344938

About the project

36 proposals

Remote project

Active 12 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

36 freelancers are bidding on average $35 AUD for this job

@RSwapnil

I have good experience of excel. I am sure I can do this with ease. Thanks

$30 AUD in 1 day

5.0

(299 reviews)

7.8

@Teloquence

Consider it done. Check your PM.

$50 AUD in 1 day

4.9

(330 reviews)

7.6

@vbexcel

Excel/VBA expert.

$30 AUD in 1 day

4.9

(33 reviews)

5.6

@Krusche

Hello. It's a kind of easy job for us. Please refer to your PMB.

$30 AUD in 0 day

5.0

(26 reviews)

5.5

@kulhanekd

I can do this project for you. Thanks Donna

$50 AUD in 3 days

4.4

(42 reviews)

5.9

@dev3dworx

Hi I am an experienced Excel Macro(VBA) developer having expertise in Excel data management apps. I can create an amazing backward solution which will generate the raw data based on summarized report. Please check my feedback scores and reviews. I am sure you will be my next satisfied client. If you have any question, please don't hesitate to ask. Hope to hear from you soon. Thanks Best Regards 3dwOrX

$50 AUD in 1 day

5.0

(23 reviews)

4.9

@microk

Macro Expert.. See attached sample..

$30 AUD in 0 day

4.8

(30 reviews)

4.4

@naveenvarthaan

Hi, I started working on your project while you will be reading this. Do you have a sample of final output (the backward one which you are expecting). Bit more clear instructions will help me fine tune my output. Thanks, Naveen

$50 AUD in 1 day

4.8

(25 reviews)

4.6

@shacoim

Hi, Excel VBA expert. I can complete this within few hours. Please check PM.

$30 AUD in 0 day

5.0

(13 reviews)

4.0

@Lotusdeveloper

Dear Peter, I can do this project in 1-2 days. Please refer the details in attached mail. Thanks & Regards, LD

$35 AUD in 15 days

5.0

(16 reviews)

3.7

@guevanjr

Please consider my bid. High quality work and timely delivery is assured. Thanks, SG

$30 AUD in 1 day

4.4

(10 reviews)

3.7

@IntellectMatters

Hi, Please note that creating entries for (390,200 + 456,060) records and applying filter on it will slow down the excel processing and mostly end up with excel not responding. Hence i can provide the pivoted excel so that you can apply filter on men/women, Categories like(married/single/love cooking). please have a look, if fine just pay me whatever you like.

$30 AUD in 1 day

5.0

(3 reviews)

2.9

@SVLakshmi

Sir, I will do this job with 100% quality. Please check your PM

$40 AUD in 1 day

4.0

(4 reviews)

3.1

@noelmartin

The raw data cannot fit in a single worksheet in Excel due to the limited number of rows. You have to use Access or an SQL server for the raw data. Please contact me for details.

$30 AUD in 2 days

5.0

(3 reviews)

2.0

@mrworker

Hi, I am offering my services for the job. Plz check Pm for detail. Thankx

$30 AUD in 3 days

4.4

(2 reviews)

1.4

@Jem1234

I have worked on similar projects several times. I am proficient in MS Excel and general internet skills. I can deliver an efficient output before the deadline.

$50 AUD in 15 days

0.0

(0 reviews)

0.0

@Aturserv

Accounting/Clerical Performed auditing work, income tax return review, taxpayer inquiry, accounting data and reports analysis and interpretation. Wrote up vouchers, examined invoices, purchase orders, receiving reports, maintained bills of lading files, handled vendors calls, researched past due invoices, maintained accounts receivable and payable books. Performed time sheet audits, entered time, processed forms, letters, documents, developed and created reports on student enrollment, assisted students, compiled quarterly student inventory, and assisted with registration for the English as a Second Language Department at University of South Alabama. Answered phones, filed, typed, input data into computer, assisted in preparation of accounting reports, and performed other general office duties. Technology Experience and training with Microsoft Word, Excel, PowerPoint, Internet Web Searches, Web page design, and teacher management software (STIweb).

$30 AUD in 5 days