cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
S229753
Helper I
Helper I

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

Hi,

 

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

 

School IDYearSemesterYear LevelAssessment ResultsNumber of studentsAssessment Criteria Name
220161Year 1E7Reading and viewing
420172Year 2A105Reading and viewing
720183Year 3C170Reading and viewing
520194Year 4B58Reading 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. 

 

1 ACCEPTED SOLUTION
S229753
Helper I
Helper I

Managed to resolve it by following the below steps. 

 

Step 1 - Create cutom column

S229753_0-1604208621811.png

 

Step 2 - Split column by Delimiter

S229753_1-1604208640860.png

 

 

 

 

View solution in original post

1 REPLY 1
S229753
Helper I
Helper I

Managed to resolve it by following the below steps. 

 

Step 1 - Create cutom column

S229753_0-1604208621811.png

 

Step 2 - Split column by Delimiter

S229753_1-1604208640860.png

 

 

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.