Detecting all the incidences of a value

Hello,

I've been working with pivot tables to try and visualize my excel sheet in a different way, but I can't get the output to look like I want it. The source spreadsheet is in 5 columns, each containing a large number of unique values. Although all the values in a column are unique, many values are in more than one column. I would like to reorganize the data so that each row contains one unique value and, in the columns to the right, a listing of the original column headings under which that value was found. Does this make sense?

For example, say I had a list of 10 individuals who went out and bought fruit. I have a table with several kinds of fruit across the column headings, and various combinations of 5 out of the 10 individuals listed in each column, corresponding to the people who bought that type of fruit. What I want is a table with all 10 people listed down a single column, and beside them, the types of fruit that each bought.

It's hard to type out anything here that would look right in terms of formatting, so hopefully my description makes sense. Apologies and many thanks in advance - I'm new to this site :-)