Creating a list from Multiple tables

[peter19041]

Hello,
I was after pulling a list with 3 Headings "Advisor" "Site" and "Date"
The list will be looking at multiple tables and advisors could work at 2 sites on the same day.

in the example i have put that advisor "Test 5" has been at Sites 1 and 3 on the same day.

is this possible at all? to show they have worked there is a 1 in the box.

i would like an entry on the list for every time there is a 1 in the box.

Hope that makes sense.

Thanks in advance
Peter

Site 1	24/03/2025	25/03/2025	26/03/2025	27/03/2025	28/03/2025	Advisor	Site	Date
Test 1	0	0	0	0	0	Test 5	Site 1	24/03/2025
Test 2	0	0	0	0	0	Test 5	Site 3	24/03/2025
Test 3	0	0	1	0	0
Test 4	0	0	0	0	1
Test 5	1	1	1	1	1
Test 6	1	1	1	1	1
Test 7	0	1	1	1	1
Test 8	0	0	0	0	0
Test 9	1	1	1	0	0
Test 10	0	0	0	0	0
Test 11	0	0	0	0	0
Test 12	0	0	0	0	0
Test 13	0	0	1	1	1
Test 14	0	1	0	0	0
Test 15	0	0	0	0	0
Test 16	1	1	1	1	1
Test 17	0	0	0	0	0
Test 18	0	0	0	0	0
Test 19	1	1	1	0	0
Test 20	0	0	0	0	0
Test 21	1	1	0	0	0
Test 22	0	0	0	0	1
Test 23	0	1	0	1	0
Test 24	0	0	0	0	0
Test 25	1	1	1	1	0
Test 26	0	0	0	0	0
Test 27	1	0	0	1	1
Test 28	1	1	1	1	1
Test 29	0	0	1	0	0
Test 30	0	0	0	0	0
Site 2	24/03/2025	25/03/2025	26/03/2025	27/03/2025	28/03/2025
Test 1	0	0	0	0	0
Test 2	1	1	1	0	1
Test 3	0	0	0	0	0
Test 4	1	1	0	1	0
Test 5	0	0	0	0	0
Test 6	0	0	0	0	0
Test 7	0	0	0	0	0
Test 8	0	1	0	0	1
Test 9	0	0	0	1	0
Test 10	0	0	0	0	0
Test 11	0	0	0	0	0
Test 12	0	0	0	0	0
Test 13	0	0	0	0	0
Test 14	0	0	1	0	1
Test 15	0	0	0	0	0
Test 16	0	0	0	0	0
Test 17	0	0	0	0	0
Test 18	0	0	0	0	0
Test 19	0	0	0	0	0
Test 20	1	0	1	1	0
Test 21	0	0	0	0	0
Test 22	0	0	0	0	0
Test 23	0	0	0	0	0
Test 24	0	0	0	0	0
Test 25	0	0	0	0	0
Test 26	0	0	0	0	0
Test 27	0	0	0	0	0
Test 28	0	0	0	0	0
Test 29	0	0	0	0	0
Test 30	0	0	0	0	0
Site 3	24/03/2025
Test 1	0
Test 2	0
Test 3	0
Test 4	0
Test 5	1
Test 6	0
Test 7	0
Test 8	0
Test 9	0
Test 10	0
Test 11	0
Test 12	0
Test 13	0
Test 14	0
Test 15	0
Test 16	0
Test 17	0
Test 18	0
Test 19	0
Test 20	0
Test 21	0
Test 22	1
Test 23	0
Test 24	0
Test 25	0
Test 26	0
Test 27	0
Test 28	0
Test 29	0
Test 30	0

 

[peter19041]