How to repeat values X times in excel | LAMBDA

=LAMBDA(values,num_repeat,
XLOOKUP(SEQUENCE(SUM(num_repeat)),VSTACK(1,SCAN(1,num_repeat,LAMBDA(a,b,a+b))),VSTACK(values,""),,-1))

[maxcrombach]

This video should get an award! Thank you for helping me out!

[Al-hivb]

Really helpful! I needed to repeat more than one column. I couldn't have done this without your step-by-step:
LAMBDA(value, repeat,
CHOOSEROWS(value, XMATCH(SEQUENCE(SUM(repeat)), SCAN(, repeat, LAMBDA(a, b, a+b)), 1)))

[DarienThayne]

This was incredibly useful and well put together. You are a true wizard. :D

[Saruman]

Wow.. this went beyond what I expected and needed. Thank you for making this video.

[MbusoThabethe]

Thank you, exactly what I needed. Brilliant tutorial.

[bali]

Astounding mastery of excel! Thank you! Was looking for exactly this! But received a lot more!

[adityakovvali]

Ma'am, you have made an amazing video, really really helpful: saved my life at 5 in the morning!

[EricHartwigExcelConsulting]

This is awesome! Thank you Karina for creating/sharing this video!

[djkujo]

You just blew my mind when you when you made this it's own formula 🤯 bravo

[mikedam]

For some reason I don't have Vstack... so the following worked for me:
(Note : I didn't put it into a named lambda function)
=XLOOKUP(SEQUENCE(sum(num_repeat), 1, 1, 1), SCAN(0, num_repeat, lambda(a, b, a+b)), values, "error", 1)

[allanwang]

Thank you so much for this fantastic video you single handedly saved my sanity!

[stevenfraser]

Exactly what I needed, great explanation!

[duckking]

really simple, just what I'm looking for.

[WrJoker]

Hey! How do you include ''calling number'' in the formula? By exemple:
Terry: (repeat 30 times the name but must have number 7 and 11 at least)
Bob: call number, 1 and 10 (repeat 10 times the name but must have number 1 and 10 at least) ?
Those ''calling number, could be chosen from another cell: 7, 11) by name.
Thanks you.

[ErickFarfan-wb]

You rock! this worked perfectly for me working with dates! subscribed!

[ahmedkanassa]

Excellent explanation, thank you very much!

[corradoagnoletto]

Hello. Interesting procedure. This could be done also with the following formula:
=LAMBDA(value, repeat, TEXTSPLIT(TEXTJOIN("/", TRUE, MAP(value, repeat, LAMBDA(a, b, REPT(a & "/", b)))), , "/", TRUE))

[georgejnrsaade]

Hi there! Great video. But my "=repeat" formula doesn't show. Seems like I don't have it. What could be the problem.

[thekeyboardguy]

Really helpful Video !!!
Keep Going ✨

[heecan]

this is really great job. but I have a problem when the repeat count is 0. While the value with 0 next to it is repeated as the number of repetitions of the lower value, and the lower value does not appear.