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 > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---