HI
I have a worksheet and I want to copy the contents of every other row for 400 rows like below with drag and fill. Excel does not understand the algorithm. How can I do that? It's 400 rows!! This goes on for columns B to F too. Pls help.
[A2]=IF(H2<>"",H2,"")
[A3]=IF(H4<>"",H4,"")...