Terminé

Excel data - add in missing rows according to rules

Missing data entry according to rules - I do not know how to write a formula for this.

There are 3199 total observations (rows). Groups of rows represent 1 person (id). For each id, some of the other variables change over time (variable in column=Time).

I need new data rows for each id such that the column "Time'' increases by sequential whole numbers for each id. The rest of the variables remain the same as for the previous row of existing data, except for 1 (id_order). This increases by 1 sequentially. All rows that are already in the current dataset ([login to view URL]) must remain. I include the main file and an example file. In the example file, the red text is for the rows of new observations that have been added. The green text is the change in the column data to account for the new rows.

Compétences : Excel, Traitement de Données, Saisie de Données, Visual Basic

en voir plus : how to insert rows in excel automatically, how to automatically add rows in excel with formula, excel formula insert row if, how to add blank rows for missing dates in excel, excel auto insert row when data changes, excel formula to insert rows between data, how to insert multiple blank rows between data in excel, excel vba insert row when value changes, excel vba add installation, excel data mining project, excel data front end, excel data formatting macro, visual basic code extract excel data, add commas excel data, excel macro add row fill data, excel vba add data, compare data add missing info excel, excel data mining add, data add excel network computer, excel data format add net

Concernant l'employeur :
( 2 commentaires ) Neutral Bay, Australia

Nº du projet : #25928976

Décerné à:

sergiuloghin

Hello! I can resolve this with a VBA script. I can finish in 1 day. You will not be dissapointed, I have a big 30% rehire rate. Thank you!

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(328 Commentaires)
7.9

72 freelance font une offre moyenne de $98 pour ce travail

schoudhary1553

Hello, I can help you to add in missing rows according to rules I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several pr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(383 Commentaires)
8.1
asin1987

Dear Employer, I understand you Excel based requirement. Please consider me for this job, I will deliver a highly professional project. My previous reviews on similar jobs can be viewed here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(204 Commentaires)
7.8
TonmoyRoy111

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. Kindly contact me. Roy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(425 Commentaires)
7.1
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do this via formula and vba script Sir for add missing data like you need please ping me now for discuss more and im free now Thank you Galih

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(406 Commentaires)
7.3
rinabuoy13

Hello, I am an independent, experienced python/c#/excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(112 Commentaires)
6.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(161 Commentaires)
6.4
RavinduJayzz

Hey there! I’m an Excel Expert. I can duplicate the data in the main data sheet and change the required fields according to your requirements and as mentioned in the excel files provided. I can start ASAP! I’ll pro Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(58 Commentaires)
6.1
younus15

Hello there. You need I group your data according to each person's unique id. Am I correct? I would do your project according to your description with highest precision and quality. I would also complete your project w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(146 Commentaires)
6.2
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL, VBA With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few pr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(53 Commentaires)
5.8
AnowarRatul

Dear sir, I have read your project details and reviewed the attachment carefully. I can resolve this with a VBA script by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro Coding, Fo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(119 Commentaires)
5.4
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
5.3
proauthor

Dear employer, I've very good experience with excel functions and can proceed with your requirement. I think the details provided in the project description are good to proceed with. Looking forward to worki Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(33 Commentaires)
4.9
suvashdev475

Greetings, I understand your project description. I think you are looking for someone for your project who expert in add in missing rows according to rules I think there is no detailed discussion of the work here. So, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(29 Commentaires)
4.8
chetandc

> Hey there, I see you’re looking for someone for "Excel data - add in missing rows according to rules " > Send me more details so we can go further. Give me one chance to give my service and make you Happy. I`m ready Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(20 Commentaires)
4.5
dissanayakepvt

Dear Sir/Madam, My professional experience includes designing, data collecting, maintaining and updating GIS databases, converting complex data into information that is easily readable and accessible to the general pub Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(5 Commentaires)
3.7
imranakbl

Dear Customer Thanks for your time to review, please. My name is Imran Sadiq an experienced resource in relevant field with more than a decade of practical presence. I have read your project detail and wants to a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
3.4
madhubv86

Hi, I have a lot of experience working with excel formulas. I understood the requirement clearly. From starting time to the ending time, we need to insert rows with a new id_order incremented by 1. Please give me an o Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
2.9
sunnykhaliq99

I am a certified accountant and Data Entry expert. I strongly believe Top Quality and Client Satisfaction are the norms of the best selling. I will accurate and professional Data Entry at a very reasonable price. I wil Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.1
sarveshram0405

Hi. I am new to this site but I am in this typing and proof reading field for past 5 years. my speed is 60wpm. I have done many conversion projects in word and Excel. I can show my work in chat. I can assure you the w Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.5
SiniyaBoroda

***Delivery within a few hours*** Hello. How are you? I have read your project descriptions in details. I am so interesting in your project as a professional expert in python scraping and building the rpa tools for ge Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.7