I need to convert a table summarising questionnaire scores (below)
Score People
5 6
4 2
3 1
2 3
1 1

into a datasheet of individuals (below)

Score People
5 1
5 1
5 1
5 1
5 1
5 1
4 1
4 1
3 1
2 1
2 1
2 1
1 1

What is the easiest way of doing this?