I got it. Here is the recursive solution to add 4 rows per each original row

with org as

(SELECT * FROM (VALUES (1, 'EXO',3 ),(7, 'SPO',4 ),(15, 'LYO',10)) AS X (ID,Workload,Units) )

, s_Recursive(ID,Workload,Units) as

(

(SELECT * FROM (VALUES (1, 'EXO',3 ),(7, 'SPO',4 ),(15, 'LYO',10)) AS X (ID,Workload,Units) )

union all

SELECT smr.id+1 as id,smr.Workload,null as Units -- incriment value 1

FROM s_Recursive as smr join org on smr.Workload = org.Workload

where smr.id < org.id+4

)

SELECT ID,Workload,Units FROM s_Recursive

order by id

;

IDWorkloadUnits

1EXO3

2EXO

3EXO

4EXO

5EXO

7SPO4

8SPO

9SPO

10SPO

11SPO

15LYO10

16LYO

17LYO

18LYO

19LYO