Hi!
First time asking a question!
I have a Microsoft Form I'm getting my team to fill in regularly. While it would be easier for me if they filled in a separate form for each staff member they spoke to, they'd prefer to do one form per event, with multiple staff. This is because there are a lot of details about the event that are the same for each staff member. I've simplified it here for a sample. When the form is completed into excel online, I get this:
What I'm aiming for is something that looks like this:
Should I be trying to use power automate? Or is there a formula i can use that will automatically move this data around?
First time asking a question!
I have a Microsoft Form I'm getting my team to fill in regularly. While it would be easier for me if they filled in a separate form for each staff member they spoke to, they'd prefer to do one form per event, with multiple staff. This is because there are a lot of details about the event that are the same for each staff member. I've simplified it here for a sample. When the form is completed into excel online, I get this:
| Event description | Event category | Event date | Staff Name | Staff ID | Staff Work Location | Staff 2 Name | Staff 2 ID | Staff 2 Work Location | Staff 3 Name | Staff 3 ID | Staff 3 Work Location |
| Event 1 | Red | 5/24/2020 | Staff1 | 1111 | Office | Staff2 | 2222 | Home | Staff3 | 3333 | On site |
What I'm aiming for is something that looks like this:
| Event description | Event category | Event date | Staff Name | Staff ID | Staff Work Location |
| Event 1 | Red | 24/05/2020 | Staff1 | 1111 | Office |
| Event 1 | Red | 24/05/2020 | Staff2 | 2222 | Home |
| Event 1 | Red | 24/05/2020 | Staff3 | 3333 | On site |
Should I be trying to use power automate? Or is there a formula i can use that will automatically move this data around?
