Hi
I'm trying to sort data in excel (see example below) that has gaps. I have tried grouping by individual risks and then sorting, but it still doesn't seem to keep the information together. How can I sort this info (sorry, I'm not an excel superuser so please explain in basic terms) so that if I sort by main contact, for example, it will keep all the info in the individual groups together?
Thanks.
<tbody>
</tbody>
I'm trying to sort data in excel (see example below) that has gaps. I have tried grouping by individual risks and then sorting, but it still doesn't seem to keep the information together. How can I sort this info (sorry, I'm not an excel superuser so please explain in basic terms) so that if I sort by main contact, for example, it will keep all the info in the individual groups together?
Thanks.
Risk | Main Contact | Secondary Contact | Status |
Risk A | Person A | Active | |
Risk B | Person B | Person A | Inactive |
Person D | |||
Risk C | Person E | Person B | Active |
Person G | Person C | ||
Person E | |||
Risk D | Person D | Active | |
Person F | |||
Person A |
<tbody>
</tbody>