Paste data into alternate blank cells [Closed]

- - Latest reply:  siju - Jun 13, 2012 at 05:45 AM
Hello, in using Microsoft Excel 2007,

I'd like to paste data from one column into a another column that has some data in it along with some blanks - but the trick is that the data being pasted from the first column into the second column can only fill in blanks in the second column! It should not overwrite any other data in that 2nd column

Example:

column1 - (column with data to be pasted - I'd copy this information)

A1 car
A2 bike
A3 motor-cycle

into column 2 below

D1 ford
D2 (blank row)
D3 10-speed
D4 (blank row)
D5 harley
D6 (blank row)

but the blanks would be filled in with the pasted data, the ending result would be

D1 ford
D2 car
D3 10-speed
D4 bike
D5 harley
D6 motor-cycle

(the rows assigned are just sample rows - not sure if rows and ranges MUST be givien to help with any formulas that may need to be created)
See more 

1 reply

Best answer
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
300
3
Thank you
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

Say "Thank you" 3

A few words of thanks would be greatly appreciated. Add comment

CCM 1926 users have said thank you to us this month

very nice idea.thanks excelguru