pivot table issue -- putting data of the same code on diff lines

i have an issue with excel that is very hurtfu

i'll put together a table with say the first column having a range of dates or perhaps keyword

second column would have product codes (often repeating product codes referring to a different column one date or keyword

third column would have numbers as in number of cases sol

then i'll make a pivot tabl

and items that have different column a values but like column b values appear on different row

THIS DRIVES ME INSANE PLEASE HELP ME
0
anonymous (74722)
5/11/2004 2:11:06 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
358 Views

Similar Articles

[PageSpeed] 13

Reply:

Similar Artilces:

Can you ignore table validation on query append?
Hello, I have a table that has validation: IIf([Document 1] Is Null,[Document 2] Is Not Null And [Document 3] Is Not Null,IIf([Document 1] Is Not Null,[Document 2] Is Null And [Document 3] Is Null)) This is because when my user fills out their form, they must select one choice from List A OR one item from List B and one item from list C. My problem is that I have an append query to add any new hires to the table in an autoexec. The append query is failing because I am not updating any data for the above Documents. Is there anyway for me to get around the table validation on my append? Any ...

Bank Rec Record Type Code?
We're trying to set up Bank Rec and can't figure out how to identify the record type code that is required by GP 8.0. Our bank doesn't provide us with a record type code so how can we set up bank rec correctly? The fields we get are: account # date amount transaction type check # description Any help would be greatly appreciated. Thanks, Mike Abrahamson If you're attempting to set up "Electronic Reconcile" I believe that the record type code relates to the records coming from your bank. You need to specify which records are headers, detail, footers. There ha...

Importing data #5
Hello, I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. Fo...

Append Query
I have a table "Rates" with the following data: StartDate: 5/15/08 End Date: 6/23/08 Rate: $53 StartDate: 6/24/08 End Date: 7/15/08 Rate: $86 StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99 I have another table "Transactions". I want to create an append query such that if I supply the StartDate and EndDate, the query will populate the "Transactons" table with date and rate data from the "Rates" table for each and every day within the date range. Example: If I supply the StartDate of 6/23/08 and the EndDate of 6/25/08, the query would pop...

printing issue
I set the print to fit to 1 pages wide by 3 pages tall and I get four pages - the last task being printed all by itself on page 4; works fine when set for 1 page wide by two pages or four pages. Searched for page breaks - none found. Any suggestions? This is a multi-part message in MIME format. ------=_NextPart_000_00FD_01CA79B9.6BC73B10 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Terry, Welcome to the Microsoft Project newsgroup :-) Please see FAQ Item: 44. Printing Problems FAQs, companion products...

How to combine/consolidate data
Hi, I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered. All data is organized in same sort of tables accross several sheets - each sheet representing different product group. So, lets say I have table organized like below: ColumnA ColumnB ColumnC Product Price Order Prod1 10 1 Prod2 20 Prod3 20 2 And I have several of such tables on different sheets corresponding to each prodcut category. Now, on the first sheet, I w...

Traspose Column data into Row
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data to be transposed, My problem is that the data i have not only has variable blocks to be transposed but also has some duplicate headings(headings are duplicate but the data in front of each heading has different value. Below is the example of data Col A Col B Col C PRODUCT COST COMPONENT COST$ A Raw Mat 10 A D L ...

Analysing data from several excel workbooks
Hi, I'm totally new to excel and i need to analyse the changes in a funding position across several years in a seperate excel sheet. As in, submissions are made year on year showing the amount of revenue spent on several different services. I need to be able to compare how those have moved over the last 5 years in a single spreadsheet. I appreciate any help. Thanks To give a clear answer we would need a bit more detail of the data layout Give us a simplified version of what the data looks like Your 'subject' talks about different workBOOKS but the text of the ...

Tutorial on line available?
Need to learn this fast. Is there an on line tutorial (free, of course) that I may use? Thanks in advance There are quite a few general ones, here's one: http://www.itts.ttu.edu/documentation/excel/excel2/exceltxti.html also, there are a lot of sites with useful information. John Walkenbach has a good list here: http://j-walk.com/ss/excel/links/ HTH tim "Semudemu" <Semudemu@aol.com> wrote in message news:03e201c34bd7$e55c9e50$a301280a@phx.gbl... > Need to learn this fast. Is there an on line tutorial > (free, of course) that I may use? > Thanks in advance &...

Creating a summary page without blank lines
I have a project where I need to determine if the billing for supplemental charges for employees matches what is actually deducted from the employee's pay check. I just started this position and what I am working with is a separate spreadsheet for each month's bill. What I have done so far is to create a spreadsheet with a tab for each month that just has the supplemental information being billed for in the left most columns and what was deducted from each paycheck in the columns to the right, a tab that lists employee names and employee numbers, and a summary page that lists...

Conditional Formatting
I have a row of cells that calculate the totals for their columns but I force to be blank via IF statements until certain conditions are met. Once these conditions are met, the total appears. I'd like to also highlight these total cells via conditional formatting. My conditional formatting input is simply "If Cell is Greater than 0, format". For some reason all the cells format as though they are all > 0 yet they don't display anything. Are there some internal rules that specifiy when a cell is really 0? Is there another way to do this that won't care what the for...

Pivot chart: get rid of zeroes?
Hi, I have created a pivot chart using a pivot table. However I want the zeroes to be NULLs so they are displayed on the graph. Unfortunately I cannot see how to do this; could someone please help? I have tried the Table Option checkboxes in the bottom right corner to no avail. Thanks Sorry, that should read NOT displayed on graphs "Phil Davy" wrote: > Hi, > > I have created a pivot chart using a pivot table. > > However I want the zeroes to be NULLs so they are displayed on the graph. > > Unfortunately I cannot see how to do this; could someone p...

Managing Data Table
Hi, I need help to wrap the tex in Data Table. If any one knows how to do it, please let me know. Thanks for your help in advance. Yogesh Hi Yogesh What version of PowerPoint are you using? What kind of table is it and how did it get there (e.g. insert -> table, or a table connected with a graph)? If it's a graph, is it an Excel graph or an MSGraph graph? Lucy -- Lucy Thomson PowerPoint MVP MOS Master Instructor www.aneasiertomorrow.com.au "Yogesh" <Yogesh@discussions.microsoft.com> wrote in message news:F68FDA89-6289-4341-8886-54C580...

Help in my VB Code .. to Delete
This is a multi-part message in MIME format. ------=_NextPart_000_0089_01C34629.B378D5B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi,=20 I have been trying to solve this problem since morning, and haven't = really come up with a solution. it is frustrating. please help. =20 i have a datagrid and got a delete column =20 <asp:datagrid id=3D"dgdocument" runat=3D"server" = AutoGenerateColumns=3D"False" EnableViewState=3D"True" = OnDeleteCommand=3D"DeleteCommand"> <Columns&...

recovering data
Money 2000: Is there a way to recover data that was not backed up. I accidently deleted all deposits. When I used the restore file procedure all saved deposits were restored, but all deposits and withdrawals that hadn't been backed up were deleted. How can I get that work back? Thanks! Retype it all? I mean, seriously, if you type three pages to a document in Word that you last backed up a month ago, delete the three pages and then quit Word where are you? "ETHORN" <anonymous@discussions.microsoft.com> wrote in message news:e40d01c3f101$8989da00$a101280a@phx.gbl...

Question with local vs. remote (Exchange server) data
Can someone please explain something basic to me about the way Outlook works. I'm a Mac user and not familiar with this thing but now need to figure out how to synchronize it with a PocketPC PDA device. We've got Outlook on our PCs (W2K), connected to an Exchange server. So, I see my calendar and contacts, which I know live on the server. But when I sync my device, it ends up empty. Is there some sort of "local" (to my PC) data that it's using instead of the Exchange server's info? If so, where is it and how do I find it? If I could find it, I could copy the Exchan...

Exchange 5.5 config issue?
We're keeping our Exchange Server without much inhouse expertise, and managing to support 140 users - so far so good. But I think we have a setting or configuration problem. If an email in a client's Outlook Inbox is there more than 2 or 3 days, reading, deleting, forwarding or any action takes about 30 seconds to execute. You get the "Microsoft Exchange is requesting Data from the server" dialog box with a subsequent 10 second or so delay, and it's annoying. Is this a caching setting on the server, and how can we extend the number of days that an email can be process...

Bytes in Data Page Row
I am reading a book titled "Microsoft SQL Server 2008 Internals". In Chapter 6, which was authored by Kalen Delaney, Kimberly Tripp, and Paul Randall, the following table and Clustered Index is created: CREATE TABLE Employee( EmployeeID INT NOT NULL IDENTITY, LastName NCHAR(30) NOT NULL, FirstName NCHAR(29) NOT NULL, MiddleInitial NCHAR(1) NULL, SSN CHAR(11) NOT NULL, OtherColumns CHAR(258) NOT NULL DEFAULT 'Junk') GO ALTER TABLE Employee ADD CONSTRAINT EmployeePK PRIMARY KEY CLUSTERED (EmployeeID) GO It states on page 321 of the aforementione...

Tax Issue
Hi again.. I have a question about taxing... I am aware that RMS allows us to change tax mode between Tax-Exclusive and VAT. However, this applies to all the transactions. This is a problem because we also sell liquor, which is tax-inclusive(all the tax, Liquor Service Tax and Good and Service Tax, are already added to the price), and the rest(price+tax) I don't know how to solve this problem... I have to make the tax appear on the receipt but not allow it to added on to the price again. Any suggestions? Regards, Joseph H The only way I know is this: You can have multiple tax type...

data import and word templates missing from CRM
Hi. I'm working with a new install of CRM and there are some icons missing in the setttings area such as the import function on the data management page and word templates under templates. Any ideas about why this is? Thanks. ...

how to create row with data
imagine i have two rows: name and color: mary blue ken brown will blue what i want is having, in another row, just the names that have blue eyes, like mary will thank you On Mon, 11 May 2009 17:26:04 -0700, rafael <rafael@discussions.microsoft.com> wrote: >imagine i have two rows: name and color: >mary blue >ken brown >will blue > >what i want is having, in another row, just the names that have blue eyes, >like >mary >will Like: mary will or like: mary will ???? ty i have excel 2000 what i want is all names in a single row, wi...

Software copy-protection strategies involving unlock codes
I would like to learn about strategies for protecting my software against illicit copying, by supplying users with unlock codes which they have to use to unlock the program's full functionality. Does anyone know of any good books on this topic, or other sources of information on it. TIA Simon I don't, although I've done a bit of work in this area myself. The first issue you need to deal with is how to stop a customer that has the code from being able to give it to someone else. I simply have the code tied to the customers name and company, if any. This way, they can st...

Add lines to a renewed contract
Whenever I try to add a new contract line while renewing a contract (ie the customer has purchased an item during the year and the contract template is coverage dates), the system rejects the new line with "invalid coverage dates". Doesnt seem to matter what dates are entered. Please advise how to add new lines while renewing a contract. Thanks Prue ...

Unknown HRESULT error code
Hello fellow newsgroupies, Does anybody know what the HRESULT error code 0x80041000 means? It is not in "WinError.h" nor does it correspond to "C:\Temp not found" (which it seems to mean in Visual Basic programs) Many thanks in advance, 'Newsgroupie' "Newsgroupie" <buzbymb@yahoo.co.uk> ha scritto nel messaggio news:5d34e73b-21b2-4786-85c7-9f66126ce83d@8g2000hse.googlegroups.com... > Does anybody know what the HRESULT error code 0x80041000 means? > > It is not in "WinError.h" nor does it correspond to "C:\Temp not > ...

How can I get data from an entity via java script
How can I get data from an entity via java The problem: I have a new entity with alle zipcodes and cities/countries. I want it to be so that if a person enters data in the zip code on account or contact that city and state automatically is filled with corresponding data from the new zip code entity. How can I do this, java script ?` Any ideas appriciated ! Jack -------------------------------------------------------------------------------- Jeg beskyttes af den gratis SPAMfighter til privatbrugere. Den har indtil videre sparet mig for at f� 13991 spam-mails Betalende brugere f�r ikke de...