Need a formula to repeat values in column A a certain number of times

Hey all,

I want to populate a column (for example, column A on the attached sheet), where the values in column A will be repeated as many times as the value in column B

Thus, the first 24 rows will say Ferrari, the next 12 rows will say Lamborghini, etc...

I need a formula that recognizes that when it gets to row 24, that it should no longer need to copy Ferrari, but then switch to Lamborghini.

I've been stabbing at this but don't know how to do this, any help would be greatly appreciated.

Thanks!

AlKey, that worked great! However, I'm having an issue. I tried to copy that formula and apply it to my workbook but it doesn't return any results.

I've attached my workbook I'm using.

I want to repeat the "Date" column (column B) on the "Master Data" tab, by the number of times in column Z on that same tab.

I want to return this information on the "Template" tab in column F under "Date"

Any help would be greatly appreciated.

Thanks

Tried it again using that formula, still won't work.

Not sure what's going on, i've attached the spreadsheet with the formula populated, it's just showing blank

Also, i need the range to go out from B2:b2000 and Z2:Z2000 (i'm just testing with two pieces of data at the moment, spreadsheet will have a lot of data going forward, which will be changing on a monthly basis

Whoops, my mistake! it works when i enter it as an array formula.

However, if i change the range to go out 2000 cells for the two columns, it doesn't seem to work

Hey PJ,

I tried using that VBA, but when I run it, it calculates the first value short 1, so instead of populating Ferrari 24 times as it should, it only does 23, the rest look good though.

I'm unfamiliar with VBA, this is my first time trying it. What would I need to change in your code to correct this, and also to capture stuff in multiple columns.

So, say I want to populate a column (using the example above), Column C to show Ferrari 24 times, etc... But also add a column to show something else 24 times in a different column.

i've attached an example of what i mean