Excel normalize column

Anonymous — Sat, 16 Nov 2024 13:24:52 GMT

hello;
I have a Excel file with 3 colums:
Date Col1 Col2
mercredi 17/01 42,06 199,20 ?
jeudi 18/01 404,74 268,92 ?
vendredi 19/01 125,32 129,48 ?
125,40 ? 358,56 ?
81,32 ?
40,66 ?
162,46 ?
1 205,10 ? 2 420,28 ? // the sum of the previous column
lundi 22/01 66,90 ? 179,28 ?

i want to get this result:
Date Col1 Col2
mercredi 17/01 42,06 199,20 ?
jeudi 18/01 404,74 268,92 ?
vendredi 19/01 125,32 129,48 ?
vendredi 19/01 125,40 ? 358,56 ?
vendredi 19/01 81,32 ?
vendredi 19/01 40,66 ?
vendredi 19/01 162,46 ?
lundi 22/01 66,90 ? 179,28 ?
Can you help me
Thank you.

Re: Excel normalize column

Anonymous — Sun, 30 May 2010 09:53:15 GMT

hi,
this is a issue of very bad organisation of a database file. you should never have null value as you have in this exel file ! thats very bad ! more... these are not really null value because it should be vendred 19/01 value... but for a computer it is a null value...
the easiest to do is to use... excel to change your file !
1) add a column "temp_date"
2) go in the first case of temp_date then
3) calculate your column with the" if"function of excel : if ( clic on comumn date) = '' then new value = (clic on column date - 1 line) else (clic on column date)
the only issu is taht the first date msut not be null !!
4) clic down to calcultate all value in your file.
5) then copy/paste to change date column and delete temp column.
and never structure a database like that again in your life !!!

topic Excel normalize column in Talend Studio

Excel normalize column

Re: Excel normalize column