Convert a summary of questionnaire scores into a detailed table

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?

Set up a cumulative score next to your existing data - assuming your data is in columns A and B, then put zero in C1 and this formula in C2:

=C1+B2

then copy this down.

Then you can use this formula in E2 (for example, with a header in E1):

=IF(ROWS($1:1)>MAX(C:C),"",INDEX(A:A,MATCH(ROWS($1:1)-1,C:C)+1))

then copy this down as far as you need it.

Hope this helps.

Pete

Thanks Pete, this will save me hours

AJ