fill up and down with multirow tool

Based on the screenshot, I want to in essence "group" the IDs and then if data is missing in a column, "fill up" or "fill down" if null/empty so that each cell is filled in. I am assuming the multirow tool be used but what is the best way to implement this?

Screenshot.png

Datasets

Accepted answers

apathetichell

use a summarize tool - group by and then take max value of any fields you wanted to "fill." Then join back on your original datastream.

All comments

cjaneczko

Do you only ever have 2 ID's that are the same or could there be more. If you had 3 for example and Field 1 was filled in on ID A1 and A3 would you fill up or fill down on A2?

apathetichell

use a summarize tool - group by and then take max value of any fields you wanted to "fill." Then join back on your original datastream.

lliberm01

Its possible I think to have up to 4 of the same ID. It could be any combination of scenarios as far as the fields. All fields may already be filled and with different info and I won't be able to determine which is best so its fine to pick either. Some may have neither and will remain empty/null. In other cases one will be chosen.

apathetichell

post some data which is closer to your actual data with the actual results you'd expect - the way your describing it has too many holes. how do you choose which value to fill an empty with if you have two different values in a data field for the same grouping?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335