Hi Prince, As mentioned earlier, i need to it this format as in Column "AA" to "AC" present in sheet below.
Thanks for your try. Average of UGX=, Cndl, Close Years date Total 1994 Feb 978.75 Mar 1016.40 Apr 986.11 May 948.24 Jun 952.28 Jul 954.15 Aug 908.04 Sep 907.76 Oct 912.19 Nov 912.95 Dec 919.82 1995 Jan 914.77 Feb 918.25 Mar 920.26 On Tue, Oct 4, 2011 at 6:55 PM, Prince Maurya <princeone.mau...@gmail.com> wrote: > Fist convert the col AE into DD-MM-YY then use pivot..in sheet 1 workn hs > done...pls chk. > > On Tue, Oct 4, 2011 at 5:04 PM, Rahul Garwad <garwads...@gmail.com> wrote: >> >> Hi Guys, >> >> Pls find below sheet and let me know how to do the Pivot present in >> Column "AA" to "AC" converting one header "DATE" into YEAR and MONTH. >> >> I want to prepare same pivot with data from Column "A" to "E" . >> >> Please let me know if i'm not clear or for more info. >> >> Regards >> >> Rahul. >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > > -- ---------------------------------------------------------------------------------- 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