Organizing data EXCEL

0

My goal is to do Cubic Spline interpolation. For this I am organizing my data as follows:

Imadeasimplemodification.IcalculatedtheusefuldaysbetweenthedayofcolumnBandthedates.ForthedatesthathavenovalueIdonotcareabouttheusefuldays.SoIgotthis:

Toconclude,myintentionistomakeatableintheseways:

Thatis,fortheday(COLUMN!!)02/01/2013inthevertex(Line)858shouldappearthevalue23.(Firsttable)fortheday(COLUMN!!)10/01/2013inthevertex(Line)852shouldappearthevalue497.(Firsttable)andsoon....

People, were you confused? I've been thinking about it all day, and I've moved on to that point. I think it might even be simple. If it is something simple is because the tiredness won me. rs

Thank you

    
asked by anonymous 24.07.2015 / 00:07

0 answers