Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Columns to table
I have about 1200 data points for temperature, taken every hour each day. The
data is in 3 columns, date, time (0:00-24:00 hrs) and the temp reading for that hour. I want to put the data into a table with date on the left column, and the values 0:00 - 24:00 across the top. This will allow me to plot the data by day, month etc. I tried a pivot table and couldn't get the data to format the way I needed it to. Are there other suggestions for automating this task? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |