I have schood data that summarises the column named 'Number of Students' as number values - See below table:
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!
Go to Solution.
Managed to resolve it by following the below steps.
Step 1 - Create cutom column
Step 2 - Split column by Delimiter
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.