Make cells repeat a set number of times

Hi all,

Back to my hostel!

We use spreadsheets for tracking groups, and some rooms sleep 2, some 4 and some 6.
We pre-populate the rooms for the leaders and then they fill in the names.

Is there a way of me setting it up for that if I pick room 6, it repeats it one more time, but if I enter Room 21, it repeats it 6 times.

Thanks in advance!