Lets say I have two column data. First column with English alphabets appearing sequentially in Capital case (A--> Z), with each alphabet appearing say 7 times before the next. The second column has the same repetition but in small case (a--z). I want keep only one entry for the small case letter in the second column for each Capital letter in column 1. Rest of the entries in second column I want to set as blanks.
(In my actual data the repetition is not fixed to 7 times and is variable. Also, my data is numerical and not character)
How to achieve this via JSL?
"Column 2 result" is what I want in "Column 2"
When it's too good to be true, it's neither