I have a list of daily river flows by year and Julian date (1-365), from 1911 to 2009, giving me a long list of maybe 35000 lines. I want to make this a table with day across the top (column labels) and year as row labels. Anyone?
I have a list of daily river flows by year and Julian date (1-365), from 1911 to 2009, giving me a long list of maybe 35000 lines. I want to make this a table with day across the top (column labels) and year as row labels. Anyone?
you need three columns - Date 1-365, another one w/ year, and the 3rd w/ the Data.
Then create a pivot table - year across the top, date left side, and data in the table.
You can find the pivot table in one of the menus. I forget exactly where now.
Yes, pivot table.
Depends if you are using Excel 2003 or 2007. Link below is for 2003. If it is 2007 then select Insert on the ribbon and pivot table.