Create new row instances for each number of students identified in the cell

[Anonymous]

Hi,

I have schood data that summarises the column named 'Number of Students' as number values - See below table:

School ID	Year	Semester	Year Level	Assessment Results	Number of students	Assessment Criteria Name
2	2016	1	Year 1	E	7	Reading and viewing
4	2017	2	Year 2	A	105	Reading and viewing
7	2018	3	Year 3	C	170	Reading and viewing
5	2019	4	Year 4	B	58	Reading and viewing

I want to create new rows for each number of students identified in the cell 'Number of new students'.

Example: If 'Number of new students' cell is '58' then create '58' new row instances of that cell.

The goal is to result in a single row for 1 student. Hence... 1 row represents 1 student. 

Appreciate the help!

Thanks,

Theo. 

[Anonymous · Accepted solution]

Managed to resolve it by following the below steps. 

Step 1 - Create cutom column

Step 2 - Split column by Delimiter