nhiribarne
03-19-2015, 11:14 AM
Hello everybody,
Please, find attached the file I'm working on.
13038
My goal is to get from the sheet "Datas" to the sheet "Resultat". I tried to do a Pivot Table but the closest Pivot Table I could have get give me 3 line for each item I need.
I was wondering if it's possible to use an excel fonction to just have the lines with the date on the Pivot Table or if it's possible to use some excel function to automatically create the table I have in sheet "Resultat" from the sheet "Datas".
Thank you very much if you can help me !
If something is not clear in my description, please, ask me :-)
Please, find attached the file I'm working on.
13038
My goal is to get from the sheet "Datas" to the sheet "Resultat". I tried to do a Pivot Table but the closest Pivot Table I could have get give me 3 line for each item I need.
I was wondering if it's possible to use an excel fonction to just have the lines with the date on the Pivot Table or if it's possible to use some excel function to automatically create the table I have in sheet "Resultat" from the sheet "Datas".
Thank you very much if you can help me !
If something is not clear in my description, please, ask me :-)