How to create template (arrange by level of detail) and any fomula for allocate data

Dear all expert.

I come back again to find any excel trick to resolve my case.

now I have detail of data, and need to create form by arrange level of detail and allocate detail data to template that I need to create. I have attached excel file and explain where is my problem.

So please help me - i really appreciate any help and suggest from all of your.

Thanks in advance

Addiaz

I think i posted in wrong thread. will remove and repost again in function and formula thread

Thx

Templates are nothing but a complex tool for formula calculation. Template are used for formula planing, activity allocation or overhead cost allocation.The template environment tells you to what you want to do with a template. There are many ways to allocate data. You can choose the way for the allocation of data.