Copy data


G

Guest

Please help if you know how to copy data from previous cell. For example, I
only have column A and column B. But I would like to have the person name on
every row. Expected result is in column C. See example below...

Col A Col B Col C (Expected Result)
John apple John
orange John
kiwi John
Mary grape Mary
banana Mary
apple Mary
 
Ad

Advertisements

G

Guest

Let's make a column C and then paste/special/value back onto column A


In C1 enter:
=A1

In C2 enter:
=IF(A2="",C1,A2)
and copy down

Then take column C, copy it, and then paste/special/value back onto column A
 
Ad

Advertisements

G

Gord Dibben

Why bother with Column C?

You can copy the names in column A to the row below.

Select column A and F5>Special>Blanks>OK

In active cell type = then point or up arrow to cell above.

Hit CTRL + ENTER

Copy column A and in place Paste Special>Values>OK>Esc.

If you want to keep column A as is just copy it to column C and perform the
above steps on column C.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top