It's in the documentation.  You're never going to get better at this if you don't even bother to try figuring this out for yourself.  I'll give you a hint, it's...

You still haven't provided sample data and expected results.  I'm not planning on spending any more time on this until you do.

Drew

Barring any additional information, I would be inclined to go with a third option that you didn't mention.  Have one table with a field that indicates source.  Otherwise you are...

I think this will get you started.  You'll need to put this in a CTE if you actually want to update the table.

SELECT *,
    CASE

Please post sample data and expected results as outlined in the first link in my signature.

Also, is your question about how to change the table structure, or how...