**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to copy a column with some blank cells to another column with some blank cells, but without replacing the other colums that have data in them.

Solved by F. D. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
26/09/2017 - 02:26

hi its sort of hard to explain what I need, so can i just show you here?

Excelchat Expert
26/09/2017 - 02:26

Welcome, Thanks for choosing Got It Pro-Excel

Excelchat Expert
26/09/2017 - 02:26

ok

Excelchat Expert
26/09/2017 - 02:27

show me

User
26/09/2017 - 02:27

so basically, I need the names in Column C to go into Column B

User
26/09/2017 - 02:27

But I dont want to get rid of the existing values in column B

User
26/09/2017 - 02:28

and I dont want to manually copy over each last name because there is way too much data. its unrealistic

Excelchat Expert
26/09/2017 - 02:29

fill data in col C

Excelchat Expert
26/09/2017 - 02:29

you need to fill data from col C to col B

Excelchat Expert
26/09/2017 - 02:30

using copy and paste you cann't do it

User
26/09/2017 - 02:30

yes exactly

Excelchat Expert
26/09/2017 - 02:30

but we can do it using another column

User
26/09/2017 - 02:30

if i use copy and paste it gets rid of the existing columsn

Excelchat Expert
26/09/2017 - 02:31

yes

Excelchat Expert
26/09/2017 - 02:32

you can do thid

Excelchat Expert
26/09/2017 - 02:32

this

Excelchat Expert
26/09/2017 - 02:32

take a look

User
26/09/2017 - 02:32

ok

User
26/09/2017 - 02:34

ok how did you do that?

Excelchat Expert
26/09/2017 - 02:34

=IF(ISBLANK(C2),B2,C2)

Excelchat Expert
26/09/2017 - 02:34

using this formula

Excelchat Expert
26/09/2017 - 02:34

sorry

Excelchat Expert
26/09/2017 - 02:34

copy the formula to the cell B2

Excelchat Expert
26/09/2017 - 02:34

to cell D2

Excelchat Expert
26/09/2017 - 02:35

and drag to all data

Excelchat Expert
26/09/2017 - 02:35

got it ?

User
26/09/2017 - 02:35

ok so basically i should save that formula

Excelchat Expert
26/09/2017 - 02:36

yes

User
26/09/2017 - 02:36

is there any way you can explain what this formula means so I can write it myself in the future?

Excelchat Expert
26/09/2017 - 02:36

ok

Excelchat Expert
26/09/2017 - 02:36

the formula is :

Excelchat Expert
26/09/2017 - 02:36

=IF(ISBLANK(C2),B2,C2)

Excelchat Expert
26/09/2017 - 02:38

if the cell C2 is blank then return the value in cell B2 , else return the value in C2

User
26/09/2017 - 02:39

ok that seems to make sense

Excelchat Expert
26/09/2017 - 02:39

cell C2 is blank ( has no data )

Excelchat Expert
26/09/2017 - 02:39

ok

User
26/09/2017 - 02:39

ok thanks for the help

Excelchat Expert
26/09/2017 - 02:39

Is there anything else you want to know regarding this issue?

Excelchat Expert
26/09/2017 - 02:39

Please give your kind feedback for our service

Excelchat Expert
26/09/2017 - 02:39

Have a good day ahead

User
26/09/2017 - 02:39

i took some notes and copied the formula on my notepad thanks

Excelchat Expert
26/09/2017 - 02:40

ok

Excelchat Expert
26/09/2017 - 02:40

note

Excelchat Expert
26/09/2017 - 02:40

if you want to delete the col B and C

Excelchat Expert
26/09/2017 - 02:41

you may first copy col D and pate it as value

Excelchat Expert
26/09/2017 - 02:41

thank you

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*