KongGulerod
New Member
- Joined
- Feb 23, 2017
- Messages
- 17
- Office Version
- 2013
- Platform
- Windows
Hi.
I'm working on a vacation calendar for a group of teams.
I have the data in a table like this:
But would like to have the data like:
Is that possible without a macro?
Would it be possible to sort the persons according to the location too?
Kind regards J
I'm working on a vacation calendar for a group of teams.
I have the data in a table like this:
| group | name | location |
| TeamA | Person1 | S |
| TeamA | Person2 | R |
| TeamA | Person3 | P |
| TeamA | Person4 | S |
| TeamB | Person5 | R |
| TeamB | Person6 | P |
| TeamB | Person7 | S |
| TeamB | Person8 | R |
| TeamB | Person9 | P |
| TeamB | Person10 | S |
| TeamC | Person11 | R |
| TeamC | Person12 | P |
But would like to have the data like:
| TeamA |
| Person1 |
| Person2 |
| Person3 |
| Person4 |
| TeamB |
| Person5 |
| Person6 |
| Person7 |
| Person8 |
| Person9 |
| Person10 |
| TeamC |
| Person11 |
| Person12 |
Is that possible without a macro?
Would it be possible to sort the persons according to the location too?
Kind regards J
