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

Ahmad
I give you the results only in one year view.
To combine the years, you need to copy & paste yourself download
ahmad.xls file at http://www.allocator.nl/upload/ahmad.xls
regards

Ahmad wrote:
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

Dear Robinific;
I can do one month using filter, from datafilterautofilter
thank you for your try
good luck
Robnific wrote:
Ahmad
I give you the results only in one year view.
To combine the years, you need to copy & paste yourself download
ahmad.xls file at http://www.allocator.nl/upload/ahmad.xls
regards

Ahmad wrote:
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

Too bad,
you did suggest Year View(s)

Ahmad wrote:
Dear Robinific;
I can do one month using filter, from datafilterautofilter
thank you for your try
good luck
Robnific wrote:
Ahmad
I give you the results only in one year view.
To combine the years, you need to copy & paste yourself download
ahmad.xls file at http://www.allocator.nl/upload/ahmad.xls
regards

Ahmad wrote:
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

I dont need months and years to appear i need just data format see my
example again

data results
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
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
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
308.3
306.0
322.0
204.5
263.0
302.9
237.4
249.3
219.3
214.6
240.7
246.8
206.5
253.0
257.9
274.0
259.0
260.2
258.9
310.3
267.4
264.4
254.6
329.2
296.0
341.3
250.4
319.8
221.6
286.2
297.1
327.6
267.5

Robnific wrote:
Too bad,
you did suggest Year View(s)

Ahmad wrote:
Dear Robinific;
I can do one month using filter, from datafilterautofilter
thank you for your try
good luck
Robnific wrote:
Ahmad
I give you the results only in one year view.
To combine the years, you need to copy & paste yourself download
ahmad.xls file at http://www.allocator.nl/upload/ahmad.xls
regards

Ahmad wrote:
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