What you really want is a pivot table.

Debra Dalgleish has extensive web pages on the subject.

http://www.contextures.com/tiptech.html

Scroll down to the P's, and check out the pages on Pivot Tables.
The last item should be an intro to them.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jennifer" wrote in message
...
If I have a spreadsheet with the following table:

Item Number Jul-03 Aug-03 Sep-03 Oct-03
ABC 15 20 50 15
CDE 20 16 - 5
FGH 1 8 22 -
IJK 6 40 - -
LMN 16 22 30 8

How can I create an arry that will give me the following output:

Item Date Qty
ABC Jul-3 15
ABC Aug-3 20
CDE Jul-3 20
CDE Aug-3 16

I am assuming I need an array formula. Thank you in advance for any help!

Jennifer