Combining information from multiple rows

I am trying to combine information from multiple rows into 
one row.

For example:
Cell A1 is Product Code, Cell B1 is Product Description 
and C2, D2, and E2 contains Product Quantity, Price and 
Total Value. 

Is there a quicker way to combine all this infomation into 
one row?

I also have problem when one product appears more than one 
with different quantity.

For example:
Product A - qty 5 Price $1.50  Total $7.50
Product A - Qty 3 Price $1.50  Total $4.50

I want to combine this so only one line of product A 
appear with total quantity of 8, price still $1.50 and 
Total $12.00. How do I do this?

0
mybakwan (1)
7/8/2004 9:40:52 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
303 Views

Similar Articles

[PageSpeed] 17

Hi
one way would be using a pivot table. Sum the quantity and 
total columns and use the maximum function for the price 
column. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm



>-----Original Message-----
>I am trying to combine information from multiple rows 
into 
>one row.
>
>For example:
>Cell A1 is Product Code, Cell B1 is Product Description 
>and C2, D2, and E2 contains Product Quantity, Price and 
>Total Value. 
>
>Is there a quicker way to combine all this infomation 
into 
>one row?
>
>I also have problem when one product appears more than 
one 
>with different quantity.
>
>For example:
>Product A - qty 5 Price $1.50  Total $7.50
>Product A - Qty 3 Price $1.50  Total $4.50
>
>I want to combine this so only one line of product A 
>appear with total quantity of 8, price still $1.50 and 
>Total $12.00. How do I do this?
>
>.
>
0
frank.kabel (11126)
7/9/2004 7:44:25 AM
Reply:

Similar Artilces:

Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when I get the answer to this, but here goes... I have a workbook containing a worksheet that records weekly data. I have a named range ("Data") which I select then clear, via GoTo. Each week, I copy the latest week's worksheet and create a new worksheet for the new week. And each week, I select the range "Data" and clear it in the most recently created worksheet. the thing is, I always thought that Range names were unique across a workbook, and that you couldn't have the same Range N...

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Locking rows, locking columns etc like MS Excel template
Found a template on Microsoft's site that it perfect for what I want t accomplish. Onlly thing is, I need to duplicate it to fit my needs. The template I'm refering to is: "Job applicant data and comparison table" found at: Templates > Microsoft Office Programs > Excel > Business > Huma Resources try the following link if interested: http://office.microsoft.com/en-us/templates/CT011356681033.aspx This brings about a lot of newbie questions to try to achieve thi exact layout. 1. how do I lock the top rows (title and column headings) so that whe I scroll the page...

Subtract several rows from a total
This is a multi-part message in MIME format. ------=_NextPart_000_0029_01C53AC8.AD6EB0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 = and have the answer in cell C41. I know that =3DC32-C34 will give me an = answer but I want several rows to be subtracted. What would my formula = be? I have used the insert function feature before but I don't see diff or = anything that looks like a subtraction function in there. =20 Thanks, Linda ------=_NextPa...

Deleting rows containing common data
I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this: 007-007 68-4611 68-4682 total 007-007 total 007-007 28-4831 68-2454 68-4682 total 007-007 28-4831 68-2454 68-4682 total 007-007 28-4831 68-2454 68-4682 total 007-007 68-4682 total 007-007 68-4682 total How do I delete the rows containing "total" One way: 1. Select the range and apply an AutoFilter (Data > Filter > AutoFilter) 2. On the drop-down list, select "Total". 3. Select the range again if needed. 5. Press F5 > Special and click "Visible Cells Only." 6. Remove...

Allen Browne Client Search Multiple Like Statements
Hi all, I need to have this code search multiple fields, but I keep getting "Expected end of statement" on the Me in the second to last line: If Not IsNull(Me.txtFilterMainName) Then 'strWhere = strWhere & "([MainName] Like ""*" & Me.txtFilterMainName & "*"") AND " strWhere = strWhere & "([Address1] Like ""*" & Me.txtFilterMainName & "*"") OR " & _ strWhere = strWhere & " ([StreetName] Like "" * " & Me.txtFilterM...

Support of multiple users in Outlook?
Hi, Palm convert here with a question. In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. from my wife as a separate user. We both had palm devices and each maintained separate schedules on our devices and on the desktop. How do we do that in Outlook? Thanks, John "John" <ljohnwu@yahoo.com> wrote in message news:u2bnY$0DGHA.3528@TK2MSFTNGP12.phx.gbl... > Hi, > > Palm convert here with a question. > > In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. > from my wife as a separate user. We both had palm ...

Multiple POP accounts in Outlook 2003
Hello, I have multiple POP accounts on my Outlook 2003 client. How do i setup Outlook to save mail from the multiple POP accounts to different folders so that it makes it easier for me to sort out my mail? TIA! //j you'll need to use rules... or use search folders configured for each account. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: ...

characters in 1 col, 1 per row
Hi all, I want to transform the text of a worddocument to Excel in a special way. In my case text is just a number of words in a number of lines (nothing special about headers, footers etc.), so something comparable with this post. I want in Excel the first charachter of the text in A1, the second in A2 and so on. This email document would result in: H i a l l , I w a n t etc. I can't figure out how to do this, your help wil be appreciated. Jack Sons The Netherlands ...

Automatic Insert Rows VBA
A Very Good Evening All, I have a macro that runs: advanced filter/copy to another place/unique, between two worksheets (Column A in each worksheet being the identfier; worksheet1 is source data,with duplicates of identifiers; worksheet2 is formula driven from the sum of the unique identifiers in Worksheet1) However...I would like the macro to automatically extend the rows in worksheet2, to accommodate the ever increasing rows of worksheet1 Here is my specific code worksheet1 = "Invoice Record" worksheet2 = "General Report" Sub CommandButton1_Click() ' A...

How to add multiple message senders to the blocked list automatica
-- Steve ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=5597e420-8dc2-4fc5-88df-130a7cc9fe32&dg=microsoft.public.outlook ...

How to combine POs to same vendor
Hello, when I print the PO Status report, I see more then one New PO being issued to the same vendor. Is there a way to combine all the POs to the same vendor? TIA Michelle ...

Transfer combined investment transactions to multiple new accounts
In Money 2005 Deluxe, I have an investment account (with related cash account) with about two years of transactions. This mutual fund account (TRP) uses a separate account number for each mutual fund holding so that when I upgraded to Money 2005 and set up on line services for this account it downloaded each mutual fund investment as a new account. I can't merge all of these duplicate accounts in Money as it only allows you to merge one time so I then transfered (using copy) all my investment transaction from the combined existing account to each of the new individual investment ac...

Some macro help
Lets say I have selected the arbitray range of j31:ax44. I want to run some macro code that will hide every column in that selection where the entire selected column range has nothing in it (blank). Data validation may be assigned to the cells, but if nothing has been selected from the drop down list, then those cells are technically blank. There may be data entered elsewhere in the column, but it is outside of the selected range and thus shouldn't be considered for being hidden or not. Can anyone help me with some code to perform this action? TIA, AlanN How about: Option Explicit Sub...

conditional formatting: separating rows with differing values
Hi, Need help with conditional fomatting. What I need: I got a worksheet with 950 rows and 5 columns. The first row contain the headers. Columns A, B, D and E contains unique values. But the column C contains text values which repeats sequentially for 6-7 rows and changes thereafter. Now I want to put up a line (using border) through the whole row dividing this transition row. My Idea: Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so on till 2 consequtive values differ. Now divide the 2 rows using the border formatting option in conditional formatting dialog box. So...

Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 6 McGrath Street # 56 7 Mary Jones 8 B45 Condo Lemon Circle . . . . . . and so on and so on every 4 cells. I have hundreds of 4 cell descriptions. I just can't do this one by one. Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I use it for e...

Removing debug information
Hello. I'm looking for a tool that removes the debug information out of an Debug Exe File. --I only have the exe file-- Thanks, Janiv Ratson. Lot of protection programs have this as part of the protection process. E.g. Crypkey advises to use a tool in their package to strip away the debug info, and to catch any debugger that attaches to the process. No need to say that a debug version doesn't make much sense any more :-) J�rgen Devlieghere "Janiv Ratson" <janiv@aoe6.net> wrote in message news:%23fgIm%23HgFHA.2424@TK2MSFTNGP09.phx.gbl... > Hello. > I'm l...

Merging to-do/task lists from multiple inbox folders
Hi- I am using Outlook 2007 and am trying to figure out how to merge to-do/task lists from multiple inbox folders. I have my inbox associated with my name, and then also a folder with my name that is associated with another inbox that is used by several people on one project. (When emails come into the latter folder, I sort the ones that I can deal with into the subfolder with my name.) For my personal inbox, I can flag emails and they will pop up in my to-do box, but when I flag things in my sub-folder they don't show up in my to-do box, and I can't figure out where t...

make dropdown list greater than 8 rows
Hello How can I make my dropdown list 12 rows instead of only 8? thanks for any help For a Forms Combo Box right click and choose Format Control-Control tab For an ActiveX ComboBox right click and choose Properties and adjust ListRows. -- Regards Dave Hawley www.ozgrid.com "SteveZmyname" <SteveZmyname@discussions.microsoft.com> wrote in message news:105058EA-1275-417C-B4BC-4023DFDAC16C@microsoft.com... > Hello > How can I make my dropdown list 12 rows instead of only 8? > thanks for any help I can change the drop down lines to 12 in the F...

Delete color row
Hi, After I compare two worksheets (VB as below) and highlight the same value with colour, now I want to delete the same value row. The comparison VB that I have worked: Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTIF(New,H5)=1" Selection.FormatConditions(1).Interior.ColorIndex = 6 How do I write VB to delete color row? Raymond ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ You can't programmatically check for a color produc...

Executable information
Hello, I have the following problem - I would like to gather information of my MFC executable. Normally one creates the company info, version number, etc. in the string table in resources. I do not know how to obtain the information. Say I write a little scanner which for every exe in a given directory obtains the information I can usually see in explorer. Thank you for help, Pshemek GetFileVersionInfo, and go to the "See also" on Version Information Overview to discover all the related APIs. Then use CFileFind and write a recursive program to find all the .exe files. joe ...

System Volume Information needed
I'm running a 3GHZ Dell with 2G RAM and WINXP Pro SP2 and a Seagate 500GB external Hard Drive. I won't bother your or embarrass me by stating I that I now have a folder on my Seagate drive entitled "System Volume Information" which doesn't belong there. It has zero folders, zero files and zero bits of information in it. It has a grayed out Read Only box under properties. I've turned off System Restore for this drive, I've of course tried delete, and I've reformatted this drive twice. I can not get rid of the folder. Again, it's on my ...

access sharepoint 2007 combining groups
I'm looking for a solution to have the possibility to give access at any SharePoint object (list/library/site) to the user combining groups. I mean the user must be on couple of groups in order to have access. E.g. User A must be in Country UK group and in Financial group for accessing on UK Financial list. How to create some like a list of checks on groups (AD or MOSS) of access on MOSS? Nope. But the solution is to simply add the proper people to the Contributor/member group for the site or list you wish to grant them access. "Marima" <Marima@discussio...

Rows and Columns #2
Hello, I have excel 2002. If I have say 100 words in the first row one in ecah column and now I want to copy the same words to have them going down the worksheet is there an easier way then copy and paste 100 times? Thanks, Bec Bec If I understand, copy all the words in the row, select a cell below the row, say A2 and select Edit>Paste special>Transpose (Checked) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "beccas1963" <beccas1963@discussions.microsoft.com> wrote in message news:C08F...

Can I format an entire row based on the value of a single cell?
I would like to use the conditional formatting feature to format an entire row rather than just a single cell. For example: If the cell value = "Total" then the entire row is bold. select your range (multiple rows???). Then with A3 (say) the activecell in that selection: format|Conditional formatting formula is: =$a3="total" apply a nice format LTShelley wrote: > > I would like to use the conditional formatting feature to format an entire > row rather than just a single cell. For example: If the cell value = "Total" > then the entire row is bo...