Brand new member. Currently working on a GIS project and trying to format County Precipitation Data for a 30-year period.
I need to transpose the TOTAL_PRECIP values into columns 1980-2010 for each FIPSID (county). They are currently arranged in 30-year (1980-2010) rows for each FIPSID. See attached excel workbook below. Mock-up of desired results is to the right of the currently formatted data. I couldn't include all the rows in the attachment due to file size, but it is still representative. In my actual data there are 92658 rows currently, the idea would be to condense it into 3,107 rows for each individual FIPSID.
I've poured through google and tried numerous formulas, nothing has seemed to work. Any help would be appreciated!
Cross-posted in Mr. Excel forum. Couldn't provide link due to error stating that I'm not allowed to post links until I post a few times. This post is the original post, will respond if other is answered. Apologies.
Bookmarks