Help

[Khalil Handal]

Hi,
I have a worksheet with 3 columns: "month, Item type, quantity" :
month Item Type quantity
Jan. 1 2
2 1
3 1

Feb. 1 2
2 2
1 3

I want to rearrange this according to "Item Type" verses "month" in a new
worksheet where it sums the quantity of each type (as follows):

Item Type Jan. Feb. ...... Dec.
1 2 5 (5
from 2+3)
2 1 2
3 1 0

Can any one have an idea?

Khalil Handal

[Ron Rosenfeld]

On Wed, 15 Mar 2006 22:36:22 +0200, "Khalil Handal" <[email protected]>
wrote:

>Hi,
>I have a worksheet with 3 columns: "month, Item type, quantity" :
>month Item Type quantity
>Jan. 1 2
> 2 1
> 3 1
>
>Feb. 1 2
> 2 2
> 1 3
>
>I want to rearrange this according to "Item Type" verses "month" in a new
>worksheet where it sums the quantity of each type (as follows):
>
>Item Type Jan. Feb. ...... Dec.
>1 2 5 (5
>from 2+3)
>2 1 2
>3 1 0
>
>Can any one have an idea?
>
>Khalil Handal
>
>

If you have a month name in each row (instead of just at the change in rows as
you show above), you could use a pivot table to easily rearrange your report.

With the cursor in the table, select Data/Pivot Table and follow the wizard.

Drag "month" to the columns area; "item type" to the rows area; and "quantity"
to the data area.


--ron