Data in wrong structure

[RichC]

Hi

I have data in a nice list:

Asset ; Date ; Feature 1 ; Feature 2 ; Value[Asset, Date, Feature1,Feature 2]

Asset ; Date + 1 ; Feature 1 ; Feature 2 ; Value[]

Asset ; Date + 2 ; Feature 1 ; Feature 2 ; Value[]

...

Asset ; Date ; Feature 1* ; Feature 2 ; Value[]

Asset ; Date +1; Feature 1* ; Feature 2 ; Value[]

and I am looking to transpose it to

Asset ; Feature 1 ; Feature 2 ; Date ; Value[;Date;;;] ; Date +1 ; Value[;Date+1;;] ; Date + 2 ; Value[;Date+2;;;]

Asset ; Feature 1* ; Feature 2 ; Date ; Value[;Date;;;] ; Date +1 ; Value[;Date+1;;] ; Date + 2 ; Value[;Date+2;;;]

...

Is there a simple way to do this? I have around 3m rows at the moment for each month of data.

After this, I plan to operate a cumulative normal function on each of the 3m Values - I am thinking of using my own function as I can't find one in the math library - any thoughts?

Many thanks & apologies if simple/mundane.

[Lee Smith]

Give an example of the date now and what you want it to be.