send a mail on excel-macros@googlegroups.com and attach the workbook On Fri, Feb 18, 2011 at 5:43 AM, RFisher <fishe...@uregina.ca> wrote:
> 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 > -- *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