View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ahmad Ahmad is offline
external usenet poster
 
Posts: 23
Default Please help me with this example

Dear all;
I have a data in one cell A, I need to distribut this data in twelve
cells
see my example

My data I need this result
year month data januray february march april may june july august september october november december
2000 januray 261.0 261.0 231.7 277.3 308.3 306.0 322.0 204.5 263.0 302.9 237.4 249.3 219.3
2000 february 231.7 214.6 240.7 246.8 206.5 253.0 257.9 274.0 259.0 260.2 258.9 310.3 267.4
2000 march 277.3 264.4 254.6 329.2 296.0 341.3 250.4 319.8 221.6 286.2 297.1 327.6 267.5
2000 april 308.3
2000 may 306.0
2000 june 322.0
2000 july 204.5
2000 august 263.0
2000 september 302.9
2000 october 237.4
2000 november 249.3
2000 december 219.3
2001 january 214.6
2001 february 240.7
2001 march 246.8
2001 april 206.5
2001 may 253.0
2001 june 257.9
2001 july 274.0
2001 august 259.0
2001 september 260.2
2001 october 258.9
2001 november 310.3
2001 december 267.4
2002 january 264.4
2002 february 254.6
2002 march 329.2
2002 april 296.0
2002 may 341.3
2002 june 250.4
2002 july 319.8
2002 august 221.6
2002 september 286.2
2002 october 297.1
2002 november 327.6
2002 december 267.5
Thank you