Pivot Table - Count data From Multiple Columns

Hi,

Need to take 'count' of data from multiple columns and show on Pivot Table

Hi All,

Have a spreadsheet that looks as follows:

Battery No : Battery No : Battery No

5 : 8 : 1
3 : 9 : 5
1 : 5 : 3

Need data to be displayed on a pivot table with count of number of times each number appears
eg. Total of 5 = 3 times; Total of 3 = 2 times etc.

Got it to work for 1 column but when I use multiple columns, total is of individual columns rather than a collective count for each piece of data.
Would like pivot to show data from all "Battery No" Columns to reflect as a column and the corresponding "Cumulative Count" to show in adjacent row

Thanks - PS: Fairly Illiterate in Excel