Combining rows of like data?

=?Utf-8?B?SnVnZ2VybmF1dA==?=

Guest

Posts: n/a

18th Sep 2006

I have a spreadsheet that contains rows with multiple entries for the same
item. How can I use a filter or a function to combine the values for the
like items in to one row?

Example:
In the same chart, item number 40-011 appears three times with quantities of
5, 3, and 2. How can I filter the data so there is one occurence of 40-011
with a quantity of 10?

« Can autofilter sum and average columns of numbers? Thank you | Time conversions »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
combining rows of data into one row	Miskacee	Microsoft Excel Misc	1	2nd Dec 2008 05:42 PM
combining rows of data	Miskacee	Microsoft Access	4	2nd Dec 2008 04:10 PM
Combining rows of like data?	=?Utf-8?B?SnVnZ2VybmF1dA==?=	Microsoft Excel Worksheet Functions	12	19th Sep 2006 03:03 AM
combining multiple rows of data into one single row of data	=?Utf-8?B?bXllcnNqbA==?=	Microsoft Excel Worksheet Functions	0	30th Mar 2006 10:39 PM
Access - Combining Data from rows	A Mackay	Microsoft Access Queries	1	16th Jul 2004 02:38 PM