Divide Value of a Cell not to exceed 999 and Copy other Row info down

[lslau]

I have this sample data:

AcctNo	Name	ReferDate	DocNo	PatientID	units	num	Code	Service	Claim ID
361004	TEST1	4/30/2013	99	1	2099	2.1	COLLECT	12/13/2016	1234568
361005	TEST2	10/31/2014	99	2	1636	1.6	COLLECT	12/13/2016	1234569
361006	TEST3	10/11/2013	99	3	1135	1.1	COLLECT	12/13/2016	1234570
361007	TEST4	4/30/2013	826	4	2548	2.6	COLLECT	12/13/2016	1234571
361008	TEST5	3/12/2015	817	5	1478	1.5	COLLECT	12/13/2016	1234572
361009	TEST6	4/30/2013	865	6	4869	4.9	COLLECT	12/13/2016	1234573
361010	TEST7	9/20/2013	99	7	1058	1.1	COLLECT	12/13/2016	1234574
361011	TEST8	12/23/2016	99	8	1265	1.3	COLLECT	12/13/2016	1234575
361012	TEST9	2/8/2013	99	9	4586	4.6	COLLECT	12/13/2016	1234576
361013	TEST10	11/22/2013	664	10	1658	1.7	COLLECT	12/13/2016	1234577
361014	TEST11	3/12/2015	99	11	1045	1.0	COLLECT	12/13/2016	1234578

<tbody>
</tbody>

Our interface will only allow a maximum of 999 units. Therefore, I need to create multiple lines of the same data that divide the units in each line as to not exceed 999.

Output Example:

AcctNo	Name	ReferDate	DocNo	PatientID	units	num	Code	Service	Claim ID
361004	TEST1	4/30/2013	99	1	699.67	0.7	COLLECT	12/13/2016	1234568
361004	TEST1	4/30/2013	99	1	699.67	0.7	COLLECT	12/13/2016	1234568
361004	TEST1	4/30/2013	99	1	699.67	0.7	COLLECT	12/13/2016	1234568
361005	TEST2	10/31/2014	99	2	818	0.8	COLLECT	12/13/2016	1234569
361005	TEST2	10/31/2014	99	2	818	0.8	COLLECT	12/13/2016	1234569
361006	TEST3	10/11/2013	99	3	657.5	0.7	COLLECT	12/13/2016	1234570
361006	TEST3	10/11/2013	99	3	657.5	0.7	COLLECT	12/13/2016	1234570
361007	TEST4	4/30/2013	826	4	849.33	0.9	COLLECT	12/13/2016	1234571
361007	TEST4	4/30/2013	826	4	849.33	0.9	COLLECT	12/13/2016	1234571
361007	TEST4	4/30/2013	826	4	849.33	0.9	COLLECT	12/13/2016	1234571
361008	TEST5	3/12/2015	817	5	739	0.7	COLLECT	12/13/2016	1234572
361008	TEST5	3/12/2015	817	5	739	0.7	COLLECT	12/13/2016	1234572
361009	TEST6	4/30/2013	865	6	973.8	1.0	COLLECT	12/13/2016	1234573
361009	TEST6	4/30/2013	865	6	973.8	1.0	COLLECT	12/13/2016	1234573
361009	TEST6	4/30/2013	865	6	973.8	1.0	COLLECT	12/13/2016	1234573
361009	TEST6	4/30/2013	865	6	973.8	1.0	COLLECT	12/13/2016	1234573
361009	TEST6	4/30/2013	865	6	973.8	1.0	COLLECT	12/13/2016	1234573
361010	TEST7	9/20/2013	99	7	529	0.5	COLLECT	12/13/2016	1234574
361011	TEST8	9/21/2013	99	7	529	0.5	COLLECT	12/14/2016	1234575
361011	TEST8	12/23/2016	99	8	632.5	0.6	COLLECT	12/13/2016	1234575
361011	TEST8	12/23/2016	99	8	632.5	0.6	COLLECT	12/13/2016	1234575
361012	TEST9	2/8/2013	99	9	917.2	0.9	COLLECT	12/13/2016	1234576
361012	TEST9	2/8/2013	99	9	917.2	0.9	COLLECT	12/13/2016	1234576
361012	TEST9	2/8/2013	99	9	917.2	0.9	COLLECT	12/13/2016	1234576
361012	TEST9	2/8/2013	99	9	917.2	0.9	COLLECT	12/13/2016	1234576
361012	TEST9	2/8/2013	99	9	917.2	0.9	COLLECT	12/13/2016	1234576
361013	TEST10	11/22/2013	664	10	829	0.8	COLLECT	12/13/2016	1234577
361013	TEST10	11/22/2013	664	10	829	0.8	COLLECT	12/13/2016	1234577
361014	TEST11	3/12/2015	99	11	522.5	0.5	COLLECT	12/13/2016	1234578
361014	TEST11	3/12/2015	99	11	522.5	0.5	COLLECT	12/13/2016	1234578

<tbody>
</tbody>

Thank you in advance for any help!