Perhaps the transpose worksheet function (see Help) will work?

"sansk_23" wrote:

If i have a Summary Sheet.1 like

Prod ID / Product Name / Jan / Feb / Mar / Apr / May / June -------
123 Book A 20 30 40 50 60 70
234 Book B 10 20 40 60 30 50

How do i get the Database Table as -
Prod ID / Prod Name / Month / Qty
123 Book A Jan 20
123 Book A Feb 30
123 Book A Mar 40
and so on & so forth.....


AND if i have a similar Summary Sheet having the Product wise Value/Price in
Sheet.2,

how do i have the Database Table as
Prod ID / Prod Name / Month / Value , where value = Sheet.1-Qty x
Sheet.2-Value.

Pls. help