Analyze some Data

已关闭 已发布的 Nov 3, 2014 货到付款
已关闭 货到付款

Hello,

I would need to group multiple records into the same record based on a common ID.

For Exemple

ID State Client Price

0001 I A 10

0001 I B 11

Result should be

ID Client ClientA Price Client ClientB Price

0001 A 10 B 11

I should also be able to manage Cancel and Cancel/Replace

New records are added with state = I (Insert).

A previous record is cancelled by providing a new record with state = C (cancelled) and the same trade identifier as the record being cancelled.

A previous record is amended using a cancel/replace approach. First, the previous record is cancelled, and then a new (replacement) record is written with state = I (insert).

Hope this is clear

thanks

数据处理

项目ID: #6681905

关于项目

8个方案 远程项目 活跃的Dec 10, 2014

有8名威客正在参与此工作的竞标,均价$98/小时

sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg 更多

$194 USD 在5天内
(15条评论)
4.6
sajidmahmud

I see your project and i do it as your acceptation. I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO and Photoshop work would like to assure you that I will do my job ac 更多

$155 USD 在3天内
(48条评论)
3.8
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio 更多

$100 USD 在2天内
(8条评论)
3.7
faheems189

Hello sir, I've read all description carefully, and i am able to show you my sample entries for multiple records, awaiting for your positive response, thanks & best regards,Faheem.

$50 USD 在3天内
(3条评论)
2.8
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. Feel free to message me with your actual data so that after you reward me I will start your project. Thank you.

$100USD 在1天里
(1条评论)
1.2
akashagoyal

A proposal has not yet been provided

$55USD 在1天里
(0条评论)
0.0
Ujitdas

good at work what ever is given to me very much serious at working time first like to finish my work and then do some gossip before that not interested to talk to anyone until and unless i finish my homework what e 更多

$222 USD 在3天内
(0条评论)
0.0
tahaouarrak

A proposal has not yet been provided

$35 USD 在2天内
(0条评论)
0.0
AlexandrK1

i can complete the task in 1-2 day please clarify do you have inforamtion about possible rows number?

$222 USD 在4天内
(0条评论)
0.0
SrinivasaBagade

Dear Employer, Good morning, I am interested in this job as I have over 18 years of experience in the field of MS excel & VBA programming, data-entry and I am a computer savoy, goals are to make the employer/ cust 更多

$30USD 在1天里
(0条评论)
0.0