Pivot data

[Prashanth7582]

Hi All,

I have an time sheet with following no of hrs logged for all resources .

Name 2011/01/01 2011/01/02
Prash 10 10
Prakash 12 15

I need the above data as below.

Name Date Hrs
Prash 2011/01/01 10
Prash 2011/01/02 10
Prakash 2011/01/01 12
Prakash 2011/01/02 15

Kindly help me in above.Advance regards.

 

[Derek Brown]

Hello and welcome to The Board.
The following shows the answer that you are looking for:
http://www.youtube.com/watch?v=mxmfOoxIVCQ
You did not say which version of Excel is being used but if it is 2007 or 2010 then Alt+D+P will get you to the Pivot Table Wizard.