SQL set values of one column equal to values of another column in the same table

Solution 1:

Sounds like you're working in just one table so something like this:

update your_table
set B = A
where B is null

Solution 2:

UPDATE YourTable
SET ColumnB=ColumnA
WHERE
ColumnB IS NULL 
AND ColumnA IS NOT NULL