Converting a table view to a dataset

[massimoo]

Hello,

I have a table which has dates in columns, item codes in rows and the items' forecast for each date.

I'm trying to convert this table in to a dataset as if it would be in a database such as:

Item1, Date1, ForecastQuantity
Item1, Date2, ForecastQuantity
Item2, Date1, ForecastQuantity
Item2, Date2, ForecastQuantity


Any ideas how to do this? There's a sample file attached.

Thanks already!

Forecast.xlsx

[nilem]

Hi massimoo,
try it

Please Login or Register  to view this content.

[AB33]

Some of the output cells have typo and I do not know what are the zeros in column G

[massimoo]

Thanks a lot nilem and AB33 for super quick replys! Great solutions!

The database requires the zeros in column G and empty values in F.

Cheers!