Then, if you need to actually transfer the content (rather than just the
reference), select column A, copy it, and choose Edit/Paste Special,
selecting the Values radio button. Click OK.

In article ,
Teethless mama wrote:

AutoFilter Blanks in Column A, now you have all the blank cells in column A
enter the formula in the first blank cell in column A
example the first blank cell is in A5. Formula in A5: =B5, drag the Fill
Handle to copy


"Colin Hayes" wrote:


Hi

In column A , I have some cells with content , some blank.

In column B , all the cells have content.

I need to transfer the content of the cells in column B to column A ,
BUT ONLY to the cells in column A which are blank.