Mass change unique values into specific cells

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

Developer Tools

Accepted answers

Qiu

I tried an aproach to be more dynamic with lookup table for the 'state specific unique value'.

0618-aarontan.yxzp

All comments

Qiu

@AaronSmatta
Sounds like a very interesting one.
Can you share some of your input data?

AaronSmatta

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.

Example Problem.xlsx

Qiu

I tried an aproach to be more dynamic with lookup table for the 'state specific unique value'.

0618-aarontan.yxzp

AaronSmatta

Thank you @Qiu

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177