Changing data representation in excel (partial transpose)

Hi All,

My source data is as below

Date	BookName	TC	Sensitivity
1-Aug-13	ABC	24	123
2-Aug-13	ABC	25	121
5-Aug-13	ABC	27	123
1-Aug-13	DEF	321	1231
2-Aug-13	DEF	319	1210
5-Aug-13	DEF	320	1230

And I want the out put to be as below:

BookName	Parameter	1-Aug-13	2-Aug-13	5-Aug-13
ABC	TC	24	25	27
ABC	Sensitivity	123	121	123
DEF	TC	321	319	320
DEF	Sensitivity	1231	1210	1230

Can this be done using Pivot?

I have also attacehd the excel sheet with input data and output format.

Can anyone please help?

Regards,
Vaibhav

If you want "Parameter" in the output chart then you would need it somewhere in the input and have Sensitivity and TC as sub points. But a question i have is are you entering the input manually or just copying and pasting?



New Here so I will do my best.

I am downloading the data from some source which gives me in the format that I have mentioned above

Parameters is just a column header. The idea is to transpose all the parameters for a given book.

bump.. no response..