Row additions in relation to a cell's value.

[MichaelNeedsHelp]

I have a database that displays "Product Name" in column A and "Number of Products Available" in column B.

Example:

My goal is to make a list that displays each individual product, creating the correct number of rows for each type of product.

Example:

Any suggestions on the best way to solve this problem are greatly appreciated. Thank you!

 

[syntaxed]

The only way I can think of is through the use of macros.

You could right-click the sheet that contains your data, left-click "View Code" and paste the following in the window that appears:

Sub MichaelNeedsHelp()
Dim myRowCtr1 As Long, myRowCtr2 As Long, myRows As Long, n As Long
Dim ws1 As Worksheet, ws2 As Worksheet
Set ws1 = ActiveSheet
Set ws2 = Sheets.Add
myRowCtr1 = 2
myRowCtr2 = 9
ws2.Cells(8, 1) = "Products Available"
Do
    myRows = ws1.Cells(myRowCtr1, 2).Value
    For n = 1 To myRows
        ws2.Cells(myRowCtr2, 1).Value = ws1.Cells(myRowCtr1, 1).Value
        myRowCtr2 = myRowCtr2 + 1
    Next
    myRowCtr1 = myRowCtr1 + 1
Loop Until ws1.Cells(myRowCtr1, 1) = ""
    
End Sub

Running this macro would insert a new sheet and populate it with data in column A, row 8 onwards as you desire.

 

[MichaelNeedsHelp]

Wow! Thank you so much. I would have never figured that out on my own! This is exactly what I needed. Really appreciate the quick help!