I have 2 columns in an excel spreadsheet, A and B. Currently column B is blank, A is populated with several thousand records. I have applied an auto-filter on Column A to limit the amount of data I can see, based on certain criteria. What I want to do is copy and paste the filtered list of data into its adjacent cell in column B. However, standard copy and paste does not seem to work this way, and pastes the data in a sequence of cells rather than 'level' with the filtered data from column A.
Is there a way to paste the data 'in line' with the filtered cells from Column A? I couldn't see anything obvious in the paste special options. I think you used to be able to move the data but I dont really want to do that either, a true copy and paste is required.