Hi Ashish, Sorry I'm really new to google groups. How do I "send" the sample workbook? Can I post it here somewhere? Thanks and sorry to ask so many questions. Ryan
On Feb 16, 8:19 pm, ashish koul <koul.ash...@gmail.com> wrote: > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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.- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
