I am trying to summarise all the data on worksheet (Tracker) to show like worksheet (Report) and I have tried using pivot table but it is not showing the data that I would like.
Your data is not suitable for a pivot table.
It should look like the table in my uploaded file.
There seems to be one or more words missing in your text.
Anyway, just show the pivot table field list to see how the pivot table is set up.
How can I get the pivot table settings to show the data in different columns like yours?
Mine is like this.
Change the layout into the tabular form.