Stack Columns

[Agamemnon]

Hi,

Probably a basic question, but I can't find a solution.

How can I stack columns into one column

Example: Current Situation

Prod Jan05 Feb05 Mar05

Prod A 1 2 3
Prod B 4 5 6

Desired Situation

Prod Month Data

Prod A Jan05 1
Prod B Jan05 4
Prod A Feb05 2
Prod B Feb05 5
Prod A Mar05 3
Prod B Mar05 6

Is this possible? Thx for your respons

Aga

 

[ColinEssex]

are you using a new field for each month?

Col

 

[Agamemnon]

Every month should be a new field.

I have another table where the months are fields and I need to link them.

 

[Rich]

You have a design flaw, do some research on normalising your data