Hi everyone, It's great to find a list with such a helpful group. I have a question. I received some recent weather data (precipitation in mm) for weather stations in Canada; however, the file isn't quite formatted for how I need it in order to analyse it. The excel file is formatting like the following (Station ID is the identification number for the station, year is the year the measurements were made, month is the month (1-12), decimals is a constant column, and the Day1-Day31 are maximum precipitation on each day of the month (see following data outline): StationID Year Month Decimals Day1 Day 2 Day3 Day4....Day 31 23056 2003 1 3 0 12.2 13 7 10 23056 2003 2 3 1 5 12 0.6 20
There are unfortunately several thousand rows and I need the table to look like the following: StationID Year Month Decimals Day Precip 23056 2003 1 3 1 0 23056 2003 1 3 2 12.2 23056 2003 1 3 3 13 23056 2003 1 3 4 7 ... 23056 2003 1 3 31 10 23056 2003 2 3 1 1 etc Note that there are several different stations, over 7 years and for all months (January to December). Thanks for any help. I hope that's enough information that you might be able to provide a way to this automatically with a macro or some other excel functions. Thanks! Ryan -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
