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"
![Neo_0-1696346824142.png Neo_0-1696346824142.png](https://community.jmp.com/t5/image/serverpage/image-id/57184iCFB880A4C88D523A/image-size/medium?v=v2&px=400)
When it's too good to be true, it's neither