Help

K

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top