How to Compile Data From a Google Spreadsheet?

[exceleer]

OK, I have a spreadsheet that looks like this:

File is in .csv format

Any way to compile data into a table that looks like this:

[FDibbins]

Not sure if this is something you can work with, but what I did was, assuming the data in the 1st table is all in 1 cell (per row), I used Text-to-Columns, delimited with a comma to produce a workable table. Then I used a Pivot table to summarize the data

[exceleer]

Here's the table in excel format:
1.xlsx

I can't summarize the data in the pivot table.

[Pete_UK]

Put A in C1 and B in D1, then put this formula in C2:

=--($B2=C$1)

and then copy this across and down to suit. You can fix the values in columns C and D and then remove column B.

Hope this helps.

Pete