OK to be more specific:

My input table is

ID | QTY | DATE
------------------
IDx QTx DTx

The output table should look like

Week1 | Week2 |........ | Weekx
--------------------------------------
IDx|QTx|IDx|QTx| .......|IDx|QTx

I don't know how I can do it without using 2 dimensional array and don't want to use pro-c.

I don't expect you to write codes just the approch should be enough if you can think of any other way. The only other way I can think of is creating x number of cursors and then inserting to the table.