Question: how to copy data from one column to another column?
Answer: Open the table with columns you want to copy and the one you want to copy into by right-clicking the tables, and then clicking Design.
Click the tab for the table with the columns you want to copy and select those columns.
From the Edit menu, click Copy.