Hello,
I have data like below, i need to create row based on two columns data.
| Year | Min_value | Max_value |
| 2004 | 1 | 6 |
| 2005 | 3 | 5 |
| 2006 | -1 | 7 |
| 2011 | -2 | 671 |
| 2016 | 148 | 5766 |
so here i need a column start with "1" for every year upto it reaches to Max_value like below.
| Year | Min_value | MAx_value | Rowcount |
| 2004 | 1 | 6 | 1 |
| 2004 | 1 | 6 | 2 |
| 2004 | 1 | 6 | 3 |
| 2004 | 1 | 6 | 4 |
| 2004 | 1 | 6 | 5 |
| 2004 | 1 | 6 | 6 |
| 2005 | 3 | 5 | 1 |
| 2005 | 3 | 5 | 2 |
| 2005 | 3 | 5 | 3 |
| 2005 | 3 | 5 | 4 |
| 2005 | 3 | 5 | 5 |
| 2006 | -1 | 7 | 1 |
| 2006 | -1 | 7 | 2 |
| 2006 | -1 | 7 | 3 |
| 2006 | -1 | 7 | 4 |
Please help me out.
Thanks in advance.