Related:
- How to paste data in alternate blank rows in excel
- Why can't i paste on instagram ✓ - Instagram Forum
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 19, 2009 at 08:06 AM
Oct 19, 2009 at 08:06 AM
Hello
Try in E1 the following formula
=IF(D1="",INDEX($A$1:$A$12,ROW()/2),D1) and drag down
Copy the results and paste special values to D1
Try in E1 the following formula
=IF(D1="",INDEX($A$1:$A$12,ROW()/2),D1) and drag down
Copy the results and paste special values to D1
Jun 13, 2012 at 05:45 AM