hinsonlam1118
New Member
- Joined
- Jan 17, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi
I am working on the name attendance list in the excel table.
The data will be filled into the excel table as below automatically by using Microsoft Form.
is there any method/programming to separate the 'Staff Name' by using ',' and go into next row? (please find the expected result as below)
For the 'Start Time', 'End Time' and 'Duration (hour)' can be copied into the related row.
It would be great if it can be automatically once the new data is filled in. if not, I could also do the exporting per month and apply the programme to separate the staff name together with their related information.
Your reply is highly appreciated and thanks so much for your help!
I am working on the name attendance list in the excel table.
The data will be filled into the excel table as below automatically by using Microsoft Form.
Start Time | End Time | Duration (hour) | Staff Name |
8:00 AM | 12:00 PM | 4.00 | Staff1, Staff2, Staff 3 |
9:00 AM | 11:00 AM | 4.00 | Staff4, Staff5, |
is there any method/programming to separate the 'Staff Name' by using ',' and go into next row? (please find the expected result as below)
For the 'Start Time', 'End Time' and 'Duration (hour)' can be copied into the related row.
It would be great if it can be automatically once the new data is filled in. if not, I could also do the exporting per month and apply the programme to separate the staff name together with their related information.
Start Time | End Time | Duration (hour) | Staff Name |
8:00 AM | 12:00 PM | 4.00 | Staff1 |
8:00 AM | 12:00 PM | 4.00 | Staff2 |
8:00 AM | 12:00 PM | 4.00 | Staff3 |
9:00 AM | 11:00 AM | 4.00 | Staff4 |
9:00 AM | 11:00 AM | 4.00 | Staff5 |
Your reply is highly appreciated and thanks so much for your help!