Add x rows in MS Excel based on Cell value

Hi everyone, I'm looking for help creating an automated task with MS Excel. Current I have a document that looks something like this... ROW USER ID NAME POINTS 1 64 Jimmy 293 2 62 Thomas 32 3 66 Jarred 20 4 67 Bill 7 5 65 Ben 5 I would like to have an automated script or formula that would allow me to add rows for each users based on the numbers of points they have. For an example let's take USER 65 (BEN)... I would like to see the following: ROW USER ID NAME POINTS 1 65 BEN 1 1 65 BEN 1 1 65 BEN 1 1 65 BEN 1 1 65 BEN 1 4 67 Bill 1 4 67 Bill 1 4 67 Bill 1 etc... So it's adding the same value based on the number of points this user has. Thanks everyone!