[Solved] Repeat cell contents specified times in separate rows

[cartoonjazz]

Thank you for your assistance. This is crossposted in LibreOffice forum https://ask.libreoffice.org/t/calc-or-b ... rows/86127. I have a table with sku# and quantity looks like

sku, qty
abc, 2
def, 3

I would like to turn it into this, the formula should repeat the sku in the next row based on the number in the qty column :
sku2
abc
abc
def
def
def

this solved in the other post https://ask.libreoffice.org/t/calc-or-b ... rows/86127

[erbsenzahl]

@cartoonjazz :: crossposting
Please inform the forum's members that you have asked the same question here: https://ask.libreoffice.org/t/calc-or-b ... rows/86127
Thank you

[cartoonjazz]

ty I have updated the post