Hi, Good question, Just double click on the data (Pivot) for which you need the detail.
On Mon, Mar 23, 2009 at 1:07 PM, raafi barey <raafiba...@gmail.com> wrote: > > Dear Ashish > > It would be really appreciated if you could help me, i am very very > bad with excel, how would i be able to display details using pivot > tables.., itried using pivot bt i m nt gettng the reuired o/p. > > Pls advice > > Regards > Raafi > On 3/23/09, Ashish Jain <26may.1...@gmail.com> wrote: > > > > Hi Raafi Barey, > > > > You need to use Pivot Tables. The output you required is perfectly > > obtainable through them even for 10 lac rows of data(not just 5000 > > rows). I've seen your file and only after that I've made this view for > > solution. Please reply, if you need assistance on Pivot Tables. > > . > > . > > . > > . > > . > > For more tips, tricks, downloads and problem solutions: visit --> > > http://www.excelitems.com > > ------------------------------------------------------------------------ > > Regards > > *Ashish **Jain* > > Analyst, CSC Australia > > Microsoft Certified Application (Excel) Specialist > > Technical Trainer - Excel and VBA > > Author -> www.excelitems.com > > +91-9999-40-48-43 > > > ----------------------------------------------------------------------------- > > > > On Mar 22, 11:15 pm, raafi barey <raafiba...@gmail.com> wrote: > >> Hello Team, > >> > >> Can anyone please help me to make my output more systamatic and > viewable, > >> I > >> have attached an excel sheet which has two tabs > >> 1.output, which shows the output format which i pull it from DB. > >> 2. Required Output, is the output which I wanted so that it is more > >> presentable, Can anyone please help me to find the solution, the output > >> which i pull is pretty shabby and confusing to look and very difficult > to > >> reconcile as it has 5000 rows in it .Its a request to all to pls provide > >> me > >> the solution. > >> > >> PFA for Reference > >> > >> Thanks & Regards > >> Raafi > >> > >> Attachment.xls > >> 18KViewDownload > > > > > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
