Unpivot A Source Crosstab Table

[#1]

Hi all,

I need your help to unpivot a crosstab table source file and once it is unpivoted, I need to load it as a regular table.

My source file looks similar to the picture below:

What I need to do is to is transpose or transform the data so that it looks like the figure below:

I am also including a sample dataset so you can you it as the source for your solution.

Thanks in advance for all your assistance and support.

[eduardo_sommer · Accepted solution]

Use Crosstable

CrossTable(Date, Forecast, 2)

Load *

From ...;

The from clause will specify the source file.

Eduardo

[#3]

Eduardo, thanks for your all your help.  The simple solution solved our problem.