Convert MS Excel Summary data into source raw data

$30-50 AUD

已取消

已发布

超过 12 年前

$30-50 AUD

货到付款

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

项目 ID: 1344938

关于此项目

36提案

远程项目

活跃12 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

36威客以平均价$35 AUD来参与此工作竞价

@RSwapnil

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

$30 AUD 在1天之内

5.0

(299条评论)

7.8

@Teloquence

Consider it done. Check your PM.

$50 AUD 在1天之内

4.9

(330条评论)

7.6

@vbexcel

Excel/VBA expert.

$30 AUD 在1天之内

4.9

(33条评论)

5.6

@Krusche

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

$30 AUD 在0天之内

5.0

(26条评论)

5.5

@kulhanekd

I can do this project for you. Thanks Donna

$50 AUD 在3天之内

4.4

(42条评论)

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 在1天之内

5.0

(23条评论)

4.9

@microk

Macro Expert.. See attached sample..

$30 AUD 在0天之内

4.8

(30条评论)

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 在1天之内

4.8

(25条评论)

4.6

@shacoim

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

$30 AUD 在0天之内

5.0

(13条评论)

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 在15天之内

5.0

(16条评论)

3.7

@guevanjr

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

$30 AUD 在1天之内

4.4

(10条评论)

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 在1天之内

5.0

(3条评论)

2.9

@SVLakshmi

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

$40 AUD 在1天之内

4.0

(4条评论)

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 在2天之内

5.0

(3条评论)

2.0

@mrworker

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

$30 AUD 在3天之内

4.4

(2条评论)

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 在15天之内

0.0

(0条评论)

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 在5天之内