Inspiration Direction with Pivoting data

[Foxy17]

Hi

Looking for some tips on where to begin with this one. I've got the data on one page as I extract it from SQLserver. I am looking for some guidance on how to get it to look more like the Idea page. Any pointer or advice would be more than welcome, many thanks in antisapation.


http://speedy.sh/MGDnK/Reg.xlsx

 

[xld]

Try this http://www.speedyshare.com/5BRbq/Chandoo-Reg.xlsx

 

[Foxy17]

Hi Xld


Many thanks for that, some very usful calculations and idea there. I've saved this one for future ref. The data I get back from the server is pependant on the register number I enter. So if I were to ask for another register number it may give a different set of days time etc.., I'll go over this more over the weekend , and many thanks for your time.