I have a very large table that includes thousands of rows. Row 1 is the header and I'd like to extrapolate each subsequent row to its own file, keeping the original header, and save each using the entry in column A. Could someone help me with a script to accomplish this?
Original table that has many entries, but reduced to two for illustrative purposes
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]12345[/TD]
[TD]LL[/TD]
[TD]HG49[/TD]
[TD]X X TM[/TD]
[TD]36[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]Jake Wilson[/TD]
[TD]67891[/TD]
[TD]BB[/TD]
[TD]dLL[/TD]
[TD]YX32 47[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
File saved as "Jane Doe.xlsx"
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]12345[/TD]
[TD]LL[/TD]
[TD]HG49[/TD]
[TD]X X TM[/TD]
[TD]36[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[/TR]
</tbody>[/TABLE]
File saved as "Jake Wilson.xlsx"
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jake Wilson[/TD]
[TD]67891[/TD]
[TD]BB[/TD]
[TD]dLL[/TD]
[TD]YX32 47[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Original table that has many entries, but reduced to two for illustrative purposes
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]12345[/TD]
[TD]LL[/TD]
[TD]HG49[/TD]
[TD]X X TM[/TD]
[TD]36[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]Jake Wilson[/TD]
[TD]67891[/TD]
[TD]BB[/TD]
[TD]dLL[/TD]
[TD]YX32 47[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
File saved as "Jane Doe.xlsx"
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]12345[/TD]
[TD]LL[/TD]
[TD]HG49[/TD]
[TD]X X TM[/TD]
[TD]36[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[/TR]
</tbody>[/TABLE]
File saved as "Jake Wilson.xlsx"
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Let[/TD]
[TD]En[/TD]
[TD]TM[/TD]
[TD]Z[/TD]
[TD]Y[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jake Wilson[/TD]
[TD]67891[/TD]
[TD]BB[/TD]
[TD]dLL[/TD]
[TD]YX32 47[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]