#24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cell
#tutorial#beginners#productivity#excel
Judith-Data-Processing-Hacks

Judith-Data-Processing-Hacks @judith677

About: esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. https://www.esproc.com/download-esproc

Joined:
Apr 20, 2022

#24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cell

Publish Date: Jul 12 '24
7 2

Problem description & analysis:
The table below has two columns, where column B is the number.

original table
We need to repeat the value of column A N times according to the value of column B and concatenate the results into one column.

desired table
Solution:
Use SPL XLL to do this:

=spl("=?.conj(~2*[~1])",A1:B2)
Enter fullscreen mode Exit fullscreen mode

As shown in the picture below:

result table with code entered
Explanation:
conj() function concatenates members of a sequence; ~2 represents the 2nd child member of the current member; “integer N* sequence” means copying each member of a sequence N times.

Comments 2 total

Add comment