wakerider017
Board Regular
- Joined
- Jun 10, 2015
- Messages
- 77
I am not sure how to do this with a data set I have...
Data:
<tbody>
</tbody>
List the week and each person that has a 'Yes' in that week.
Would prefer to do this in a pivot (if possible), as the actual data set is quite large (~50,000 records).
Filter to only show group A
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Data:
Customer | Group | Week 1 | Week 2 | Week 3 | Week 4 |
Bob | A | Yes | Yes | Yes | |
Mark | B | Yes | Yes | ||
Sue | A | Yes | Yes | ||
Tim | A | Yes |
<tbody>
</tbody>
List the week and each person that has a 'Yes' in that week.
Would prefer to do this in a pivot (if possible), as the actual data set is quite large (~50,000 records).
Filter to only show group A
Result: | |
Week 1 | Sue |
Week 2 | Bob |
Week 2 | Sue |
Week 2 | Tim |
Week 3 | Bob |
Week 4 | Bob |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>