This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.