Make a report that looks like a pivot table

[John@backacre.co.uk]

I have about 600 people names and 60 ish tasks to allocate across typically 3 days. It seems easier and more natural to allocate tasks to people as the check box list is much shorter, and the tasks are stylised so there are few that have the same initial letter so the check box search is easy. The people are listed in sequence and their willingness to do a job is indicated above the check box for the day. That's how the access job is set up.
Now comes the problem: how to get a display that succinctly presents the information for a) checking whilst planning, and b) checking that all the folk have turned up. It only takes 3 pages of paper, or two clicks of a mouse, to show the whole plan when using the present spreadsheet.
Using access pivot table, I can get a list of tasks down the left column with the people dong the tasks each day lined up alongside for the 3 days. However, because some of the tasks involve 20 or more people, the pivot table doesn't show all the data: the scroll bar within a column has to be used to display the hidden people, making it unsuitable for printing. Very close to the beautifully clear spreadsheet alternative, but useless.
I have tried to invent a way of "splicing" the daily info together using a succession of queries, but have realised that the task of creating a "pivot table" presentation is beyond simple queries. So, I either need help with code, or at least a strategy for the code, or other presentation report format.

 

[John@backacre.co.uk]

I had a suggestion from jassaal123 but a crosstab doesn't produce the result I need. the data I have looks like the following (much simplified).
The Initial info where a task is allocated to a name.
Name FriTask SatTask SunTask
NA TC TC
NB TC TC TC
NC TC TC
ND TB TB
NE TD TD TD
NF TA TA
NG TB TB
NH TC TC
NI TB
And so on. Multiple people, some with same task and some doing every day

Final display required looks like
Task FriName SatName SunName
TA NF NF
TB ND NI ND
TB NG NG
TC NA NA NB
TC NB NB NC
TC NH NC NH
TD NE NE NE
I also made a table with columns Task, Name, Day using queries, and then a crosstab but that fails because the crosstab only allows First, Last for the data under the date columns.
Hope this helps to further define my problem.