Consolidate a table with keeping 3 column criteria

[nhiribarne]

Hello everybody,
Please, find attached the file I'm working on.

Test 1.xlsx

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 :-)

[nhiribarne]

Nobody able to help me ?

[jonh]

Select the Pivot sheet
Go to the Design menu
Select 'show in tabular form' from Report Layout
Select 'don't show subtotals' from Subtotals

[nhiribarne]

Ok, that's alreqdy way better that I was doing.
But, do you know if there is any possibility for me to have the Asset description and the Asset class in line 7, 9, 10 and 12 after I do what you told me?

Or the somplest way is to paste as value and create a IF formula saying if the cell is empty, then take the value of the cell right above the actual cell?

Thanks

[nhiribarne]

Ok, found it.
Just have to had "repeat label" in the field setting.
Thank you very much John. I tried mulptiple thing in the Design but could not reach this point without your help.

Have a good day.

Subject solved