I have a large spreadsheet which has street addresses, then a few cells beneath has the city. I am trying to move the city into the cell directly next to the street address. (column C has street address, i would like to move all cities to column D). I have tried a few different methods, none of which seem to be helping. I would think there is a formula or function i could use.... but am not having luck on the google trying to figure out how to craft a formula for this. My thinking is i should be able to drag a formula all the way to the bottom, then copy and paste the values entirely to a new sheet.
Could someone help me please? Sample File attached