View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
 
Posts: 120
Default I need to help with Excel (beginner) -- year row and month column

Hello all,

I would like to know how to do the following ( I am newbie to
Excel :) )

I have this

2004-11-30 10
2004-12-31 7
2005-01-31 5
2005-02-28 20
2005-03-31 19
2005-04-30 17
2005-05-31 16
2005-06-30 15
2005-07-31 18
2005-08-31 8
2005-09-30 9
2005-10-31 8
2005-11-30 9
2005-12-31 4
2006-01-31 15
2006-02-28 23
2006-03-31 15
2006-04-30 6
2006-05-31 2
2006-06-30 1
2006-07-31 3
2006-08-31 3
2006-09-30 2
2006-10-31 2
2006-11-30 5
2006-12-31 11
2007-01-31 2
2007-02-28 3
2007-03-31 4
2007-04-30 5
2007-05-31 6
2007-06-30 14
2007-07-31 13
2007-08-31 12
2007-09-30 11
2007-10-31 4
2007-11-30 3
2007-12-31 9
2008-01-31 9
2008-02-22 7

and I would like to obtain the folloling

Jan Feb Mar Apr May Jun Jul
Aug Sep Oct Nov Dev Total
2008
2007
2006
2005
2004

any appreciation will be welcome
Thank you in advance