For a Pivot you would need to transpose your data set first I'm afraid.

If your data is really numeric you could use the set as is by using formulae to generate the frequency table

Assume your matrix is A1:C4 (headers row 1) then:

E1: battery
E2: 
=IF(MAX($E$1:$E1)=MAX($A$2:$C$4),"",SMALL($A$2:$C$4,1+COUNTIF($A$1:$C$4,"<="&N($E1))))
copied down to say D10 (possible 9 unique values)

then

F1: count
F2:
=IF($E2="","",COUNTIF($A$2:$C$4,$E2))
copied down to F10