Mate, That was the only solution I had for your problem if, you wanna use column based data structure. A suggestion for you, get rid of this column based data structure or use SPSS.
And most important, the sheet I had sent you can be used for next 17 years (If you are good in mathematics). You can always change the column headings to row and vise versa in Pivot table. Let me know if you wanna go with my solution, We can refine the sheet further. Guys, I dont have any other solution (using pivot) for his query. Please assist him for other better options. Thanks & Regards, *Harmeet Singh* *IT Analyst * *McKinsey & Company * On Tue, Mar 31, 2009 at 6:22 PM, ankur lodha <ankurlod...@hotmail.com>wrote: > hi harmeet > > you dint get my question.. for your type of solution i've to get everything > in rows viz. against each date ive to get 10 names then the date changes.. > > i do not want to remove names from column headings.. > > please see the file.. that is the original file.. if you could please form > a pivot in that only and mail me the same.. i shall be very grateful.. > > ankur lodha > > ------------------------------ > Date: Tue, 31 Mar 2009 14:33:27 +0530 > Subject: $$Excel-Macros$$ Re: pivot table help > From: harmeet.hew...@gmail.com > To: excel-macros@googlegroups.com > CC: ankurlod...@hotmail.com > > > Mate, > see attached file. > That is self explanatory > > On Tue, Mar 31, 2009 at 12:12 AM, ankur lodha <ankurlod...@hotmail.com>wrote: > > > hi everyone > > i've a task to prepare an attendance register of 10 candidates at my > office.. i'm stuck in pivot table formation.. I'm attaching the sheet for > your perusal.. > > I want name of candidates in rows.. present / leave / comp off / holiday > being the column header and count of presents / leaves .. etc. pertaining to > each in data field.. > > eg: > present leave holiday comp off > names count of each > > > Please help.. > > > ankur lodha > > ------------------------------ > So many new options, so little time. Windows Live > Messenger.<http://www.microsoft.com/india/windows/windowslive/messenger.aspx> > > > > > > -- > Thanks & Regards, > > Harmeet Singh > > > > -- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
