hakunamatata167
New Member
- Joined
- May 11, 2017
- Messages
- 8
Hi All,
I have a large database which I am working on and one part I'm stuck on is merging rows to give one result.
i.e. here is some mock data:
<tbody>
</tbody>
And here is what I would like:
<tbody>
</tbody>
As you can see, basically I need a way to merge cells and if they match a criteria in the time column, replace this with a summary term - for example morning+afternoon+evening would equal triple session; morning+afternoon would equal all day
Thanks for any help and ideas
I have a large database which I am working on and one part I'm stuck on is merging rows to give one result.
i.e. here is some mock data:
Date | Time | Speciality | Location | Person |
15/04/18 | morning | TeamCap | Brooklyn | Captain America |
15/04/18 | afternoon | TeamCap | Brooklyn | Captain America |
15/04/18 | evening | TeamCap | Brooklyn | Captain America |
15/04/18 | morning | TeamStark | Long Island | Iron Man |
15/04/18 | afternoon | TeamStark | Long Island | Iron Man |
<tbody>
</tbody>
And here is what I would like:
Date | Time | Speciality | Location | Person |
15/04/18 | Triple Session | TeamCap | Brooklyn | Captain America |
15/04/18 | All Day | TeamStark | Long Island | Iron Man |
<tbody>
</tbody>
As you can see, basically I need a way to merge cells and if they match a criteria in the time column, replace this with a summary term - for example morning+afternoon+evening would equal triple session; morning+afternoon would equal all day
Thanks for any help and ideas