1-If any row in column A is empty enter "Unassigned" but only do so if Column B in that same row is not empty

2-If any row has empty fields in both column A and B switch column c of that same row to column D of the prior row.

I need to do this for 14k rows is there any formula or macro that might be able to do this?