Multi-Row Cleaning

[Jay_Koda]

Hello,

 I am working with a twitter data set and some of the individual tweet information was carried over to the following row. Where 23231320 should line up, the 73 should line up, and the other two following in those null spaces. Pretty much, the 4 nulls in row 45 should be replaced with the 4 values in row 46.  It appears at random throughout the entire data set.  "73" is the only consistent value throughout the data set.

This being said, I am hoping someone can help me clean up this issue. Please help! 

[fmvizcaino]

Hi @Jay_Koda ,

Attached is an example showing how to do it.

My idea was to identify the columns that differ based on the null value in last column.

Best,

FErnando Vizcaino

[Jay_Koda]

Thank you, but this seems to only work for the one record rather than multiple records that are random throughout the data set

[fmvizcaino]

@Jay_Koda ,

I've created more lines to the example and it worked like a charm!

Take a look and let me know if this works for your data as well.

Best,

Fernando Vizcaino

[Jay_Koda]

The formula tool dividing/round/multiply to get matching recordID's was not working for me. This being said, I replaced this with a multi-row formula tool and wrote a conditional statement to replace the recordID with the following row ID if a Null was present. 

Thanks for the advice and help!