[TABLE="width: 500"]
<tbody>[TR]
[TD]Location
[/TD]
[TD]#
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[/TR]
[TR]
[TD]NYC
[/TD]
[TD]5
[/TD]
[TD]July
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Florida
[/TD]
[TD]3
[/TD]
[TD]August
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Mass
[/TD]
[TD]1
[/TD]
[TD]October
[/TD]
[TD]2019
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 167"]
<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>[TR]
[TD="width: 97, bgcolor: #B1E0A4"]Location[/TD]
[TD="width: 43, bgcolor: #B1E0A4"] # [/TD]
[TD="width: 46, bgcolor: #B1E0A4"]Month[/TD]
[TD="width: 36, bgcolor: #B1E0A4"]Year[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Massachusetts[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Location
[/TD]
[TD]#
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[/TR]
[TR]
[TD]NYC
[/TD]
[TD]5
[/TD]
[TD]July
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Florida
[/TD]
[TD]3
[/TD]
[TD]August
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Mass
[/TD]
[TD]1
[/TD]
[TD]October
[/TD]
[TD]2019
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 167"]
<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>[TR]
[TD="width: 97, bgcolor: #B1E0A4"]Location[/TD]
[TD="width: 43, bgcolor: #B1E0A4"] # [/TD]
[TD="width: 46, bgcolor: #B1E0A4"]Month[/TD]
[TD="width: 36, bgcolor: #B1E0A4"]Year[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New York[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jun[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Florida[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Massachusetts[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"]Jul[/TD]
[TD="bgcolor: transparent"]2019[/TD]
[/TR]
</tbody>[/TABLE]