Please help me with this example

A

Ahmad

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
 
A

Ahmad

Dear Robinific;
I can do one month using filter, from data>filter>autofilter
thank you for your try
good luck
 
A

Ahmad

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help; data filter 10
excel help 2

Top