#24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cell
Judith-Excel-Sharing
Posted on July 12, 2024
Problem description & analysis:
The table below has two columns, where column B is the number.
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.
Solution:
Use SPL XLL to do this:
=spl("=?.conj(~2*[~1])",A1:B2)
As shown in the picture below:
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.
💖 💪 🙅 🚩
Judith-Excel-Sharing
Posted on July 12, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.
Related
tutorial #24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cell
July 12, 2024