It is hard to give you a good answer because I don't know for how many items
you need to perform this conversion for and if you are doing it to multiple
items the spacing and header rows for each item. There is one problem that
need to be fixed no matter which methoid you use. Your month names either
need to be spellout completely or use the standard 3 letter abrevation for
each month name in both the source table and where you want the results to go.

It would also help to give the sheet name(s) and the rows and columns where
the data is located.

" wrote:

How can I get below info to show as:

A1 B1 C1
Item number 894011 Bag Poly w/snaps for 6x9 mats

Requirement date Month Calculated Opening Inv.
8/1/2008 August 0
9/1/2008 September -624
12/1/2008 December 2,076
1/1/2009 January 1,932
3/1/2009 March 1,452
================================================== ================================
Like this


Aug. Sept October Nov. Dec
Item number 894011 Bag Poly w/snaps for 6x9 mats 0
-624 #N/A #N/A 2076

Some months are in order some of them are not the way you see above.

thanks
Vedat