use transpose (ctrl+shift+enter)
On Fri, Feb 18, 2011 at 9:17 AM, ashish koul <koul.ash...@gmail.com> wrote: > 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 > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- ---------------------------------------------------------------------------------- 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
