Need to convert multiple columns into 1 colum in MS Access table

Hi,
I have a table which has dates & quantity going across as columns.  I
need to get the dates in only 1 column & the dates in another
column.
How do I do this in vba?

Here is a sample:
ID	Fname	Lname	ProductID	Order Date 1	Order Qty 1
100	William	Smith		4/9	8
102	N	West		4/9	8

Order Date 2	Order Qty 2	Order Date 3	Order Qty 3
4/9	                 8
Order Date 4	Order Qty 4                Order Date 5	Order Qty 5


I need the table to be in this format:
ID	Fname	Lname	ProductID	Date	Quantity

What is the easiest way to do this?

Thanks!