daydaym0919
New Member
- Joined
- Feb 28, 2019
- Messages
- 1
Test1 | Test2 | Test3 | Test4 | |
Name1 | Score | 4 May | Score | 4 June | Score | 4 July | Score | 4 Aug |
Name2 | Score | 4 July | |||
Name3 | Score | 4 June | Score | 4 July | Score | 4 Aug | |
Name4 | Score | 4 June | Score | 4 Aug |
<tbody>
</tbody>
Ie. Person A took their 3rd attempt on 4 May, Person B took their 1st attempt on 4 May. I cannot click on “4 May” to see both Person A and B because they were different attempts….
I am trying to create a pivot table or something that will allow me to filter through all the dates (in different columns of my worksheet) and give me the names and scores of everyone that took the test on that date. If anyone has any ideas, suggestion it would be greatly appreciated.
It's kinda similar to the table I showed, but a bit more complex. The score breakdown and the dates are in separate columns. The "|" between the score and date is to show the separate columns.