Multiplying the amount of rows by a certain number

[BillyL14]

Hi all

I have a table like this.

2a

2b

2c

2d

I would like the frequency of the value in this table to increase based on the week I put.

For example if the above was week 1, this would be week 2

2a

2a

2b

2b

2c

2c

2d

2d

I have tried messing around with the multi row formula but not really not getting anywhere

Thanks a lot

[PhilipMannering · Accepted solution]

So something like this?

[BillyL14]

yes that looks great, haven't used that tool before, thanks!