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
Bookmarks