Stuckinarut
New Member
- Joined
- Feb 19, 2006
- Messages
- 9
Greetings, Pivot tables used to be the bulk of my working life 10 years ago but recently I have become silly and excel has progressed. I need to organise data like this:
https://docs.google.com/spreadsheet/ccc?key=0AjQhaNj2nHHOdDFJaDJXY1BmZG5FcVJaUTdiRzQzcHc&hl=en_US
So I can then use pivot tables/chart to analyse it. The real data is exponentiatlly more complex.
My skills with the pivot are now upto speed after spending the last three days trying, testing and reading.
If you could please make any suggestions on my source data layout so I can get pivot friendly data, it would be much appreciated by this old fool.
Thank you very much.
https://docs.google.com/spreadsheet/ccc?key=0AjQhaNj2nHHOdDFJaDJXY1BmZG5FcVJaUTdiRzQzcHc&hl=en_US
So I can then use pivot tables/chart to analyse it. The real data is exponentiatlly more complex.
My skills with the pivot are now upto speed after spending the last three days trying, testing and reading.
If you could please make any suggestions on my source data layout so I can get pivot friendly data, it would be much appreciated by this old fool.
Thank you very much.