See the attached example... is there a way to copy values from column C to column A, but shifting them down to the respective blank rows? But leaving the data in column A intact?

This is part of a much larger dataset and simply putting them at the end will not work. All the data in C needs to shift down one and over two.

Thoughts?

copy_paste.xlsx