Excel VBA User Defined Function To Generate A Dynamic Array – 2516

Can Excel VBA return a dynamic array from a user defined function to the grid?
Can you repeat each cell in column A based on the number in column B?

Check out the amazing answers from Smozgur and XLLambda here:
https://www.mrexcel.com/board/threads/repeatbynumber.1216836/

Table of Contents
(0:00) Two titles
(1:11) Using VBA
(2:05) How many cells to return
(2:50) Building the array
(3:22) Return array to grid
(4:00) Using Hash array operator