Once I create my pivot table it has all the data I need but then I need to
use that data for another purpose and the best way to do that is to use it as
a table format.

My question is, once the table is created it populates the first row and
column with the necessary data, for example; apple. then the next 40 lines
consist of data regarding 'apple' and then line 42 is 'orange'; and so forth.
How can I get the pivot table to list apple in all the lines for apples?

Any information would be greatly appreciated.