Generate an Attendance report in multiple rows and columns in Excel format

[Firdaus_AG]

Hi everyone, Please help to generate a report in Excel format as I described below from the table ATTENDANCE.

If I have the table in AppSheet named ATTENDANCE

id	user_id	user_name	user_status	user_name
1	1	John	Present	10/17/2023
2	2	Sarah	Present	10/17/2023
3	1	John	Absent	10/19/2023
4	2	Sarah	Present	10/19/2023
5	3	Zack	Absent	10/18/2023
6	2	Sarah	Present	10/20/2023
7	1	John	Absent	10/20/2023
8	1	John	Present	10/21/2023

How to generate the following report in Excel format:

#	Name	ID	10/17/2023	10/18/2023	10/19/2023	10/20/2023	10/21/2023
1	John	1	Present	N/A	Absent	Absent	Present
2	Sarah	2	Present	N/A	Present	Present	N/A
3	Zack	3	N/A	Absent	N/A	N/A	N/A

[AleksiAlkio]

It should be doable. Let me think..

[AleksiAlkio]

Yeap, it's possible. There could be an easier way but this approach is what came to my mind first.
EDIT: With this approach I have another table called "Startdate" with one row where you can select the start date.

[AleksiAlkio]

Result PDF was like this. It should work with the XLSX template as well. The "N/A" is added only to the first column.

[Firdaus_AG]

Thank you. I will try and let you know the result.