Could someone direct me as to the cleanest formula that would copy a cell from one column into another and then paste it down to the appropriate cells in that column? This might be a Do Until piece of code instead of a formula. Would love some guidance.
The attached should help make it clear. Thank you! EE-Copy-Test.xlsx