How to create duplicate row for multiple output for single row

I am fetching data from website using input from excel file but for few inputs I am getting multiple records so how can copy a same excel input row for output. right now I got the data but I don’t know how to create duplicate row. now my write range override that output row on same line one same row. like i have a one row as a input but i have 7 rows of output.

data.xlsx (8.4 KB)
I ATTACHED A EXAMPLE FILE LIKE FIRST ON SHEET 1 AND OUTPUT ON SHEET2 PLEASE HELP ME.