Mar 11 2019 09:41 PM
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.
Please help.
Mar 12 2019 08:09 AM
Hello
Your data is not suitable for a pivot table.
It should look like the table in my uploaded file.
Mar 12 2019 04:12 PM
Mar 12 2019 10:00 PM
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.
Mar 20 2019 04:57 PM
Thanks.
How can I get the pivot table settings to show the data in different columns like yours?
Mine is like this.