(see attached worksheet)
Windows 10 Excel 2019
I have 2 columns of data in my worksheet.
I need to move column D info to one-off rows in column A
Example: D1 should be moved to A2. D5 should be moved to A6 and so on.
There are thousands of rows, so I can?t just move the entire column, because it would overwrite the data in rows 3,4,7,8,11,12,19,20 of column A, etc.
Is there a way to do this in an automated way without ctrl-clicking on each cell in column D? (there are 1000?s of them)
Thanks in advance