Creating a horizontal data table from a Pivot Table with vertical data

[Leeds15]

I have a pivot table that I need to create a second table from. I need the pivot table results to be moved from a vertical format to a horizontal format in the second table. Can this be done with a formula or macro? I do not want to transpose. See my example below. Thx

PIVOT TABLE DATA:

1 | 25 |
5 | 12 |
5 | 26 |
17 | 10 |
30 | 11 |
30 | 17 |
30 | 21 |
30 | 45 |
30 | 50 |



HORIZONTAL TABLE RESULTS

1 | 25 | | | | |
5 | 12 | 26 | | | |
17 | 30 | | | | |
30 | 11 | 17 | 21 | 45 | 50 |

 

[SpillerBD]

So instead of the Label in the Row you want it in the Columns....

 

[Leeds15]

So instead of the Label in the Row you want it in the Columns....

In the Pivot Table, the first column is UPC numbers and the second column are interchanged SKU's. There can be multiple SKU's to the same UPC so I would like to create a second table that lists each UPC number from the Pivot Table with each on the interchanged SKU's listed one by one in the cells to the right of the UPC number. Below is how I would like the new table to look like. Does this help?


UPC Number 1 SKU1
UPC Number 2 SKU1 SKU2
UPC Number 3 SKU1
UPC Number 3 SKU1 SKU2 SKU3

 

[SpillerBD]

eww. That breaks a couple of rules I try to always follow. So in concept I'm mentally handicapped to approach what I don't like.
It will take a macro, and some one who has a good handle on a macro for that purpose can probably modify one to this need.
I don't run a un-pivot macro for a couple of reasons.

Since both UPC's and SKU's could theoretically begin with zeroes, these should be text strings.
(There's also something in the back of my mind that I've seen this problem and a solution in the past in this forum, but finding the right search term might keep it hidden.)

see... http://www.mrexcel.com/forum/excel-questions/869536-combine-like-fields-pivottable-combine-not-like-fields-into-one-field-separated-commas.html