Choosing??

[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

 

[Khalil Handal]

Hi,
Sorry,
I posted in the wrong group.


Khalil

 

[Joseph Meehan]

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

Sure you can sort on any field in a query, report or form.

Do you need more help?

 

[Danny J. Lesandrini]

Is this data in Access or Excel?

If Access, then I'm assuming that Month column is actually filled
for each row. If so, then have you tried to create a crosstab query?
I think that would work here.

 

[Larry Daugherty]

You will have better luck getting responses to worksheet posts by
posting them into newsgroups that support worksheets.

HTH