Hi Everyone,
I have a problem where I added a new row for each of the 50 states and the new row essentially duplicated the last row of the state. I was wondering if there is an efficient way to replace the value in a specific column of the new row. The values I want to use to replace are specific to each state. Currently I am using the Formula tool and manually typing 50 IF THEN statements to change the value in the new row. I feel like there has to be a better way because if data to each state changes, then the formulas would all have to change. Any help will be much appreciated. Thank you in advance.
Best,
Aaron
Solved! Go to Solution.
@AaronSmatta
Sounds like a very interesting one.
Can you share some of your input data?
Hi @Qiu,
Please see attached for the example Input Data similar to my situation. In the attachment you will see that there is a duplicate jurisdiction row for each state. I would like to change the value of the duplicate 'Jurisdiction' to '[State Code] payment' (For example, in CA I would like the second 'Jurisdiction' to be 'CA payment') and for the duplicate 'Estimates' to a state specific unique value. Hope this helps.
Thank you @Qiu
@AaronSmatta
Glad to help and thank you for the accept mark.