Pivot or something else?

[jaryszek]

Hi,

I have a problem with pivot table.

I added attachment.

From table like this:

Company Process document 1 document 2 document 3
Google Process 1 lack lack send
Google Process 2 send lack lack
Microsoft Process 1 lack send send

I would like to get table for report like this:

Company type of lacking documents Count of documents
Google Document 1 1
Google Document 2 2
Google Document 3 1
Microsoft Document 1 1


Can anyone help me please?

I will be grateful,
thank you in advance,
Jacek Antek