title: spreadsheet missing data for corresponding cells
body: <p>I have a problem with missing data of corresponding column.
  Column A has unique value which corresponds to specific cities in Col B. But few cells in col B is empty. It is long spreadsheet. How to fill col B from the values of corresponding col A automatically?</p>
  <p><a href="https://i.stack.imgur.com/qcwRE.png" rel="nofollow noreferrer">enter image description here</a></p>