Compile empty field with a data present in the same column

Hi there!
I have an issue.

I have the following data:

ST OBJ CITY
R-PC-023 R-ST-MISUR GOSSOLENGO
R-PC-023 R-ST-ABC
R-PC-023 R-ST-BCDE
R-PC-023 R-ST-POMP
R-PC-023 R-ST-SCR GOSSOLENGO

My goal is to compile the “City” column when it is empty.

The ST is the “key” for extract the “city”.

Thank you in advance

It’s unclear to me what exactly it is that you’re trying to accomplish. What do you mean by “compile” ?

Do you have an example of your desired output?

1 Like

Issue has been solved as following:

  1. I extraced all Comune for each ST
  2. In my main “file”, for each ST i added the Comune from extraction at point 1
  3. Dropped the Comune column of my main file because i appended the new one of point 2

image

image

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.