Hi all!
I am trying to condense temperature data taken every hour for years by way of a pivot table. To give it meaning for my work I would like to find daily and weekly averages, mins and maxs. I attached an example spreadsheet.
When i try to drag and drop or insert by way of wizard->layout the Date-Time variable into the Row Fields section it will not show up. The only part of the table it will drop into is the 'Data Field' section.
I am using excel 2008 for Mac.
Any advice would be greatly appreciated.
Bookmarks