I can drop the column by recreating the view, but I also need
to copy the data from one column to another.

How do I do this ?