Related:

- How to paste data in alternate blank rows in excel
- Transfer data from one excel worksheet to another automatically - Guide
- How to take screenshot in excel - Guide
- Number to words in excel - Guide
- How to calculate position in excel ✓ - Office Software Forum
- How to change author in excel - Guide

## 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