hello everyone,
i have a table like below picture:
i want to give specific amount of number from user ( the amount of number is based on unique values in state field- for example in above picture we have 5 unique state then we should give 5 number from user) with inputbox and paste the number for each state.
the result should be the below picture
can anyone help me with this??
i have a table like below picture:

i want to give specific amount of number from user ( the amount of number is based on unique values in state field- for example in above picture we have 5 unique state then we should give 5 number from user) with inputbox and paste the number for each state.
the result should be the below picture

can anyone help me with this??