can you please send the sample workbook
On Thu, Feb 17, 2011 at 3:03 AM, RFisher <fishe...@uregina.ca> wrote: > 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 > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
