Dear All, I have a table with the following structure
I need to have it however
I've tried out Pivoting, group by ID, VALUE but then cannot do aggregation ...
Using OpenOffice, it is simply a Pivot, grouping ID and VALUE , and counting unique ID.
Example (in Microsoft Excel format ) done in OpenOffice is attached.
Here is the solution of the problem: duplicating the ID column and then grouping by ID and VAL and manual aggregate on ID using counts.