tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 375
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi All
Below is a before and after of what I need to achieve but need help to do it please:
The list needs to group all the same names together. create a space between the names and show a colour separation. The list varies in length.
Thank you
Below is a before and after of what I need to achieve but need help to do it please:
Name | VisitType | Visit Id | Start Time | End Time | Status | Assignee |
Visit | Care and Support | 1698630 | 12/Jun/2023 09:30 | 12/Jun/2023 13:30 | Outstanding | Homer |
Visit | Care and Support | 1701871 | 12/Jun/2023 10:00 | 12/Jun/2023 17:00 | Outstanding | Lisa |
Visit | Care and Support | 1695733 | 12/Jun/2023 14:00 | 12/Jun/2023 17:00 | Outstanding | Homer |
Visit | Care and Support | 1704225 | 12/Jun/2023 17:30 | 12/Jun/2023 18:30 | Outstanding | Homer |
Visit | Care and Support | 1704614 | 13/Jun/2023 08:10 | 13/Jun/2023 09:40 | Outstanding | Marge |
Visit | Care and Support | 1697314 | 13/Jun/2023 09:15 | 13/Jun/2023 10:15 | Outstanding | Homer |
Visit | Care and Support | 1704272 | 13/Jun/2023 09:00 | 13/Jun/2023 13:00 | Outstanding | Bart |
Visit | Care and Support | 1704610 | 13/Jun/2023 10:00 | 13/Jun/2023 13:00 | Outstanding | Lisa |
Visit | Care and Support | 1627915 | 13/Jun/2023 10:00 | 13/Jun/2023 14:00 | Outstanding | Marge |
Visit | Care and Support | 1704267 | 13/Jun/2023 13:30 | 13/Jun/2023 16:30 | Outstanding | Bart |
Visit | Care and Support | 1704241 | 14/Jun/2023 09:30 | 14/Jun/2023 14:30 | Outstanding | Marge |
Visit | Care and Support | 1704616 | 14/Jun/2023 14:45 | 14/Jun/2023 15:45 | Outstanding | Marge |
Visit | Care and Support | 1705038 | 14/Jun/2023 12:00 | 14/Jun/2023 16:00 | Outstanding | Lisa |
The list needs to group all the same names together. create a space between the names and show a colour separation. The list varies in length.
Name | VisitType | Visit Id | Start Time | End Time | Status | Assignee |
Visit | Care and Support | 1704272 | 13/Jun/2023 09:00 | 13/Jun/2023 13:00 | Outstanding | Bart |
Visit | Care and Support | 1704267 | 13/Jun/2023 13:30 | 13/Jun/2023 16:30 | Outstanding | Bart |
Visit | Care and Support | 1701871 | 12/Jun/2023 10:00 | 12/Jun/2023 17:00 | Outstanding | Lisa |
Visit | Care and Support | 1704610 | 13/Jun/2023 10:00 | 13/Jun/2023 13:00 | Outstanding | Lisa |
Visit | Care and Support | 1705038 | 14/Jun/2023 12:00 | 14/Jun/2023 16:00 | Outstanding | Lisa |
Visit | Care and Support | 1698630 | 12/Jun/2023 09:30 | 12/Jun/2023 13:30 | Outstanding | Homer |
Visit | Care and Support | 1695733 | 12/Jun/2023 14:00 | 12/Jun/2023 17:00 | Outstanding | Homer |
Visit | Care and Support | 1704225 | 12/Jun/2023 17:30 | 12/Jun/2023 18:30 | Outstanding | Homer |
Visit | Care and Support | 1697314 | 13/Jun/2023 09:15 | 13/Jun/2023 10:15 | Outstanding | Homer |
Visit | Care and Support | 1704614 | 13/Jun/2023 08:10 | 13/Jun/2023 09:40 | Outstanding | Marge |
Visit | Care and Support | 1627915 | 13/Jun/2023 10:00 | 13/Jun/2023 14:00 | Outstanding | Marge |
Visit | Care and Support | 1704241 | 14/Jun/2023 09:30 | 14/Jun/2023 14:30 | Outstanding | Marge |
Visit | Care and Support | 1704616 | 14/Jun/2023 14:45 | 14/Jun/2023 15:45 | Outstanding | Marge |
Thank you