cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors