Creating a new table from another - filtering out unwanted data
in [Functions]
|
From: Kamalii on 12 Mar 2010 12:36 Here is my table for sheet1: Shipment No. Product No. of Pieces A pencil 1 B pen 1 A eraser 1 A paper clip 2 B stamp 3 C ruler 1 B calculator 2 I am trying to create a new table in a new sheet (sheet2) that will list all the products and pieces that were part of shipment no. A This is what I would like it to look like Product No. of Pieces pencil 1 eraser 1 paper clip 2 How do I go about doing this? Please help!
From: Eva on 12 Mar 2010 12:48 Hi The best and most flexible way is to create a pivot table. Data/Pivot table report/next/highlight your range - the best way is to highlight all columns/next/layout/drag "Product" to row and No. of Pieces to data (make sure that it shows you sum)/OK/finish -- Please click "yes" if this post helped you! Greatly appreciated Eva "Kamalii" wrote: > Here is my table for sheet1: > > Shipment No. Product No. of Pieces > A pencil 1 > B pen 1 > A eraser 1 > A paper clip 2 > B stamp 3 > C ruler 1 > B calculator 2 > > I am trying to create a new table in a new sheet (sheet2) that will list all > the products and pieces that were part of shipment no. A > > This is what I would like it to look like > > Product No. of Pieces > pencil 1 > eraser 1 > paper clip 2 > > How do I go about doing this? Please help!
From: Ashish Mathur on 14 Mar 2010 07:17 Hi, You may refer to question 7 at the following link - http://ashishmathur.com/knowledgebaseII.aspx -- Regards, Ashish Mathur Microsoft Excel MVP "Kamalii" <Kamalii(a)discussions.microsoft.com> wrote in message news:31531F13-6C35-4134-B36D-CB375788A914(a)microsoft.com... > Here is my table for sheet1: > > Shipment No. Product No. of Pieces > A pencil 1 > B pen 1 > A eraser 1 > A paper clip 2 > B stamp 3 > C ruler 1 > B calculator 2 > > I am trying to create a new table in a new sheet (sheet2) that will list > all > the products and pieces that were part of shipment no. A > > This is what I would like it to look like > > Product No. of Pieces > pencil 1 > eraser 1 > paper clip 2 > > How do I go about doing this? Please help!
|
Pages: 1 Prev: How do I lock ONLY the formatting on an excel sheet? Next: Repeat Rows but not on every page! |