#45 — Copy Each Row N Times (N Is The Cell Value of The Specified column)

Problem description & analysis:
In the Excel table below, each row is a product, and the 3rd column is the quantity of the product.

Task: Copy each row N times (N is the cell value of the 3rd column) and display values in the original 3rd column as empty. The expected result is as follows:

Solution:
Use SPL XLL to do this:

=spl("=?.conj(~3 * [~]).run(~3=null)",A2:F9)

As shown in the picture below:

Explanation:
conj()function concatenates members of a sequence. run() function modifies a sequence. “Integer N* a sequence” means copying members of a sequence N times.