Trying to make a pivot table that combines 4 columns of data into one field.

I'm not able to read the attachment at work but my guess is that your requirement is pretty simple.

You need to stack the fields in your row labels but you also need to have some kind of value to put in the Values section. Without a defined value, the pivot table won't go. Can you do a count of products?

The problem with stacking (assuming you mean just having 4 rows per product with a different location in each) is that all my data is drawn from a (terribly laid out) constantly changing worksheet that I cannot change the formatting of, and I need a sustainable solution that shouldn't involve manually stacking the data each time I want a current pivot table. I've solved my own problem for now by creating a macro that temporarily creates 4 versions of every product, (each representing a different location,) creates a pivot table from that, and then deletes the stacked data. This works for now, but it seems overly complicated for what is presumably a pretty common issue....

I think the easiest way to do it would be, to just create a big Pivot Table that takes:
Locations as the Row Labels,
Product as the Column Labels,
Quantity + Reserved Quantity as the Values,

And then turn Grand Totals on for rows, so it will create a column at the right that's the summation for all the locations.

Well, I'm getting the "invalid attachment specified" error, so I can't test this hypothesis on your data.

Yeah it definitely would, but it doesn't address my biggest problem. My fields are Product, Location1, Quantity1, Reserved1, Location2, Quantity2, Reserved2, Location3, Quantity3, Reserved3, Location4, Quantity4, Reserved4.

If I choose Location1, Location2, Location3, Location4 as row labels, it nests them all instead of just combining them. I need some way of taking those 4 fields and creating one master Location field, while maintaining the individual Quantity and Reserved values for each.

Hi,

I guess this can be done by changing the Pivot Table Layout to "Classic View". Please post a sample template of your workbook using "Go Advanced" option.