SQL MS ACCESS: Split row into multiple based on column value
I create number table which contain value from 1 to 10,you may populate it with more as per your requirement.

Table name tblNumber (RowNumber number)

SELECT country, rownumber
FROM tblNumber AS N INNER JOIN table3 AS t ON n.rownumber&lt;=t.noofpages;


here table3 is your table.