Hi all,
Is there a way to transform my data from this to the one below?
JAN | FEB | MAR | APRIL | MAY | JUNE | JULY | AUG | SEP | OCT | NOV | DEC | |
2010 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
2011 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
Jan-10 | 1 |
Feb-10 | 2 |
Mar-10 | 3 |
Apr-10 | 4 |
May-10 | 5 |
Jun-10 | 6 |
Jul-10 | 7 |
Aug-10 | 8 |
Sep-10 | 9 |
Oct-10 | 10 |
Nov-10 | 11 |
Dec-10 | 12 |
Jan-11 | 13 |
Feb-11 | 14 |
Mar-11 | 15 |
Apr-11 | 16 |
May-11 | 17 |
Jun-11 | 18 |
Jul-11 | 19 |
Aug-11 | 20 |
Sep-11 | 21 |
Oct-11 | 22 |
Nov-11 | 23 |
Dec-11 | 24 |
Solved! Go to Solution.
thank you Ryan, works well