I am using a Pivot table to consolidate data that I export to another application. I am having a formatting problem in the table. In the table when the data element in the first column has multiple items to report in the second column I can not get the data in the first column to display in each row.
I have included an example to try to illustrate the problem. My data is more complicated then this example with multiple columns. In my example name 1 and name 2 has sales for items a, b and c. Very simply, how do I get the