Please help making pivot table of count values from multiple columns!

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Body

I've got 6 columns full of data entries that vary from 1 to 6. I'm trying to create a pivot table that will tell me a count of each 1, each 2, each 3, etc for each column.

However the only way I can get the Row in the pivot table to show the way I want means that whenever I add another column to the data, it just repeats the data of the first column.

Here's a couple screenshots, one of my raw data, and the other of the way I would like my pivot table to look (despite the Product 2 having useless repeated data in it).

http://imgur.com/MWaIp,9LE9J#0

How do I set up my pivot table to show a count of each Product's contents?

Thanks in advance!

Author

Account Strength

90%

Account Age

14 years

Verified Email

Yes

Verified Flair

Total Karma

4,858

Link Karma

1,064

Comment Karma

3,794

Profile updated: 3 days ago

Posts updated: 1 year ago

larkns

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 13 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...