Pivot Table - Output Text Values instead of Number Count

[krazykato83]

I have an Excel sheet with a list of part numbers and vendors associated wtih those part numbers. For example:

Part Number Vendor
Part 1 A
Part 1 B
Part 2 A
Part 3 B
Part 3 C
Part 4 A
Part 4 B
Part 4 C
Part 4 D

When I run a Pivot Table, using 'Count of Vendor' only returns the number of vendors for each part number. For example:

Part Number Count of Vendor
Part 1 2
Part 2 1
Part 3 2
Part 4 4

However what I NEED is to output the vendor names for each part number in separate column cells. For example:

*******************************************
Part Number Vendor Vendor Vendor Vendor
Part 1 A B
Part 2 A
Part 3 B C
Part 4 A B C D
*******************************************

How can this be achieved? I've tried various 'Value Field Settings' and changing number format to text, but no dice. There has to be a way to do this...

 

[krazykato83]

Perhaps it may be better to understand with the revised format below:

**************************************

I have an Excel sheet with a list of part numbers and vendors associated wtih those part numbers. For example:

..Part | Vendor
Part 1 | A
Part 1 | B
Part 2 | A
Part 3 | B
Part 3 | C
Part 4 | A
Part 4 | B
Part 4 | C
Part 4 | D

When I run a Pivot Table, using 'Count of Vendor' only returns the number of vendors for each part number. For example:

..Part | Count of Vendor
Part 1 | 2
Part 2 | 1
Part 3 | 2
Part 4 | 4

However what I NEED is to output the vendor names for each part number in separate column cells. For example:

*******************************************
..Part | Vendors
Part 1 | A | B
Part 2 | A
Part 3 | B | C
Part 4 | A | B | C | D
*******************************************

How can this be achieved? I've tried various 'Value Field Settings' and changing number format to text, but no dice. There has to be a way to do this...

HELP!

 

[IamTheMaster]

This s the exact solution you are looking for Excel: Pivot Table Text Value Instead of Counts For Sub-group Listings