OT: Excel macro help

Since this is a large collection of very smart people, hopefully someone here can help out my dumb self.
I have an excel sheet that has 3 columns of data.
The first columns is number of points, second column is setpt A, and third is setpt B. So for example if the first row has:
3, 10, 5 I need to copy that data to 3 rows with each row being 10, 5. The number of points can be 1 to perhaps 50, so the number of rows copied will be different. What whould I need to do in a VBA script to copy this data? I've attached a picture of what I have and the end result needs to be. Thanks

Paste this code into excel VBA. It's quick and dirty but it worked once in a row. Which is as many times as I tested it.
Sub Setpoints()


Dim Num_Point_array(100, 100, 100)
Dim x, y, z As Integer
Dim Num_points As Integer
Dim Setpt_A As Integer
Dim Setpt_B As Integer
Dim StartRow As Integer
Dim index As Integer
Dim lRow As Long

z = 1
'Find the last non-blank cell in column A(1)
lRow = Cells(Rows.Count, 1).End(xlUp).Row

StartRow = lRow + 5 ' start about 5 down from the end
index = 1
For x = 2 To lRow
Num_points = Cells(x, 1).Value
Setpt_A = Cells(x, 2).Value
Setpt_B = Cells(x, 3).Value

For y = 1 To Num_points
Cells(StartRow, 1).Value = index 'point number
Cells(StartRow, 2).Value = Setpt_A
Cells(StartRow, 3).Value = Setpt_B
index = index + 1
StartRow = StartRow + 1

Next y


Next x


End Sub

You're awesome! Thanks!

No problem. If this were something you were going to use a lot I would build the macro to put the results on a separate sheet or another workbook and of course put in a button to initiate it.