hakunamatata167
New Member
- Joined
- May 11, 2017
- Messages
- 8
Hi All,
I need help merging multiple rows which match certain criteria (i.e. cells matching for date, specialty, location and person) to produce one entry, for example
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Would condense down into:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
e.g. if all other cells match, then morning+afternoon+evening would equal triple session; moring+afternoon would equal all day.
Thanks for any help/ideas
I need help merging multiple rows which match certain criteria (i.e. cells matching for date, specialty, location and person) to produce one entry, for example
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 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Would condense down into:
Date | Time | Speciality | Location | Person |
15/04/18 | Triple Session | TeamCap | Brooklyn | Captain America |
15/04/18 | All Day | TeamStark | Long Island | Iron Man |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
e.g. if all other cells match, then morning+afternoon+evening would equal triple session; moring+afternoon would equal all day.
Thanks for any help/ideas