I am trying to display multiple Columns of identical information without a Dropdown with the columns side by side and only appearing once.
My base information is as follows:
SKU Title Shipped
123-BJ00040-14 Betsey Johnson Women's BJ00040-14 2
123-BJ00131-29 Betsey Johnson Women's BJ00131-29 2
123-BJ00198-02 Betsey Johnson Women's BJ00198-02 2
123-BJ00131-29 Betsey Johnson Women's BJ00131-29 4
123-BJ00040-14 Betsey Johnson Women's BJ00040-14 3
In other words I have Row data with multiple columns of the same information for example the Column SKU always correlates to the Column Title. I am trying to view both the SKU and Title as non expand/collapse columns in the pivot and only SUM the Shipped Column so my pivot table should look like:
SKU Title Shipped
123-BJ00040-14 Betsey Johnson Women's BJ00040-14 5
123-BJ00131-29 Betsey Johnson Women's BJ00131-29 6
123-BJ00198-02 Betsey Johnson Women's BJ00198-02 2
Allowing me to copy the SKU, Title and Summed Shipped Qty together.