Pivot table - summary

Copper Contributor

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.

5 Replies

Hello

 

Your data is not suitable for a pivot table.

It should look like the table in my uploaded file.

 

Hi Thanks Detlef. In the pivot table, how can I items in the row into the columns like you?

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.

 

screencap.png

 

@Detlef Lewin 

Thanks.

How can I get the pivot table settings to show the data in different columns like yours?

Mine is like this.