Auto duplicate rows
 

Is there a way to have a row copied/duplicated automatically?

Here is the problem:
1. I have a row with 1 column with a list of 4-5 items with all the same information.
2. Example: 3-4 phone numbers for 1 house. Same address and same description and same ranking.
3. I have a column listing how many numbers are listed in that 1 column/row box
4. my problem is that the 3-4 numbers need to be on each individual row
5. I was copying the entire row 3-4 times. Then deleting out the phone numbers to have only 1 phone number for the whole row.

The solution of automatically doing this will save me the time of manually doing with a copy, paste, and delete.

Any help will be greatly appreciated.

Thanks,
Ty