Gurus,
Not sure if I did the justification with the Subject. However, here is where I am stuck.
I have two columns; A and B (as below): Total (current) rows 20000+
| | A | B |
| 1 | 103XFSGS | |
| 2 | 10XFSFRW | 1-3 |
| 3 | 20X4952DF | |
| 4 | 10X48520K | 1-3 |
What I need to do is to split row number 2 and row 4 in to multiple of 3 rows, and replace the values with 1-3 because column B indicates that values of 'x' should be from 1 to 3. The position of X is at constant 3 from left therefore this rule does not apply to row 1; also it does not apply on row 3 because it does not start with 10X.
Expected Result:
| | A |
| 2 | 101FSFRW |
| 2 | 102FSFRW |
| 2 | 103FSFRW |
| 4 | 10148520K |
| 4 | 10248520K |
| 4 | 10348520K |
Sounds interesting?
/ps: Thanks in advance for your time.
