I have a spreadsheet where there are random values going down Column C that I want to select and paste into the corresponding row in Column B. The corresponding cells in Column B are always blank. All the cells between the random values in Column C are blank. There is content in the other cells in Column B that I don't want to overwrite, nor do I want to move them at all. I I know I can select the cells in Column C using Go To Special, but once I've identified them, I can't get them to just scoot over one cell. Any ideas?
Bookmarks