Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have a table with a lots of Years and a values.
Eg.
Year value
2012 1200
...
I would like to generate within my script a table which
splits these values into the months:
Eg:
YearMonth value
2012-01 | 100 |
2012-02 | 100 |
2012-03 | 100 |
2012-04 | 100 |
2012-05 | 100 |
2012-06 | 100 |
2012-07 | 100 |
2012-08 | 100 |
2012-09 | 100 |
2012-10 | 100 |
2012-11 | 100 |
2012-12 | 100 |
Can anyone tell me how to generate this ?
I hope an easy task for the experts, but I am still beginner
and appreciate your help.
Cheers
Joerg
Dear Jagan
Also a nice solution for me.
Thanks a lot.
Joerg
Hi,
Could you please share the code here. Is that using IterNo() function?
Thanks!