Hi, I have the same question as in this thread but I could not solve it based on the provided answer.
The question is: how from source data like this..
..create pivot table like this?
The original thread has an attached file as a solution but I cant understand how to do it. I have these problems with it:
1. The Alt,D,P to open pivot wizard does not work. It opens Text to Column window instead. How can I open the wizard?
2. The macro button "refresh" generates new random data in the source but the pivot table does not update. When I press "refresh" button in the ribbon it gives error. Also Change Data Source button gives error.
3. How to create the "Column" field with [Orig;Real] data points? And how to create the "Value" field with all the dates in it? When I create my own pivot table from the source data I get three columns (Proj;Orig;Real) with data in them from respective columns.
I use Excel 2010, Czech version, Win7. I wanted to reply in the original thread but it wont let me to post question in other member's thread..
Thanks in advice for any help!