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.