How to fill sequence in Excel from ranges given in another sheets?
- by amyassin
I have an Excel sheet where two columns (say J and K) among data in sheet1 are as follows:
J ------------ K
1 ----------- 25
26 --------- 50
101 ------ 150
Which are some ranges. I have another sheet where I have column (let's say I), which I want to update it to have the values as indicated by the range; i.e. column values of I to be 1,2,3,...25,26,27,...50,101,102,103,...150 (vertically). Note that ranges in J-K are not always continuous (e.g. gap between 50 and 101) and not always in the right order.
I'm trying to find some automated way to achieve that, instead of manually copying the starting value of the range (from I) and then dragging down sequentially until the ending value (from J) for every individual I and J value, which is a very huge set of data. Is there any way to help doing that?
Note: I'm using Microsoft Excel 2013, but a solution for excel 2010 or 2007 is more than welcomed...
