Search : in
By :

Paste data into alternate blank cells

Last answer on Oct 19, 2009 1:06:58 pm BST johnnyj, on Oct 17, 2009 2:04:44 am BST 
 Report this message to moderators

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)

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « paste data into alternate blank cells » in :
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Inputs / Outputs: The streams in C ++ ShowInputs / Outputs: The streams in C ++ Open a file for reading Open a file for writing To save data after closing your programs, you must write the data into files. Here is how to proceed. To open a file, either for reading...
Graphics cards - Video cards Show2D Accelerator Cards A graphics card, sometimes called a graphics adapter, video card or graphics accelerator, is a computer component which converts digital data into a graphical form which can be displayed on a monitor. The initial role of a...
BinHex encoding ShowBinHex encoding BinHex encoding (a contraction of binary-to-hexadecimal) is a proprietary algorithm owned by Apple for converting 8-bit binary data into a 7-bit format. BinHex encoding, designed for Macintosh systems, is used to preserve file...
Uuencode/Uudecode ShowUuencoding UUencode encoding (a contraction of Unix-to-Unix encode) is an algorithm for converting 8-bit binary data into a 7-bit format. Uuencoding was originally created for sending binary files using the email protocol uucp. The uucp system...
Ask your question Reply

1

 Excelguru, on Oct 19, 2009 1:06:58 pm BST

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
A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help