Insert # Rows based on numeric cell value and copy entire row to all inserted rows help

[Keith412]

Location	#	Month	Year
NYC	5	July	2019
Florida	3	August	2019
Mass	1	October	2019

<tbody>
</tbody>

I have a workbook with the above information:


I would want it to look at column B, (#) and then insert 5 rows where the #= 1, so 1,1,1,1, instead of the 5:

Location	#	Month	Year
New York	1	Jul	2019
New York	1	Jul	2019
New York	1	Jul	2019
New York	1	Jul	2019
New York	1	Jul	2019
Florida	1	Jun	2019
Florida	1	Jun	2019
Florida	1	Jun	2019
Florida	1	Jul	2019
Massachusetts	1	Jul	2019

<colgroup><col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <tbody> </tbody>

 

[Keith412]

Actually I tweaked it and I got it to work, but not for the last four columns (they all show as blank). Example of columns H through K

Month	Year	Finance Salary	$ Run Rate
Jul	2019	12,257	12,257

<colgroup><col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <tbody> </tbody>

 

[Fluff]

Do you have a header in every column of row1?