I need an Excel expert to create a formulae

Job ID: 33872250

Budget: ₹750 – ₹1,250 INR

We need to generate some random numbers but the numbers should be specific to certain range defined by our Management.
For example we need to generate random numbers in between 1-5 provided 54 column has to populated with number 1, 20 columns has to populated with number 2, 20 Columns has to be populated with number 3, 5 columns has to populated with number 4 and so we.

It a very repetitive task we need someone to make a formula for us to solve this problem
Related categories: Excel Statistics