menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Productivity News

>

#140 — Gen...
source image

Dev

1w

read

137

img
dot

Image Credit: Dev

#140 — Generate Continuous Arrays

  • The task is to expand the two numbers in each row into continuous number intervals.
  • Solution: Use SPL XLL and enter the provided code to split the numbers and form a continuous sequence.
  • The code loops through each row, splits the numbers using the minus sign, converts them to an integer sequence, and then expands each row into multiple rows based on the number of members in the sequence.
  • Download esProc Desktop for free to reshape your data with SPL XLL.

Read Full Article

like

8 Likes

For uninterrupted reading, download the app