Hi,
I am just starting to learn about Pivot Tables (Excel 2010), and have a question that is probably painfully obvious to you pros - so please bear with me!
In the work sheet, I have a sorted table consisting of 2 columns: Column A contains one of 3 stores, Column B contains merchandise. I would like the Pivot Table to have 3 columns with Column Labels = the 3 stores, and then the merchandise under the column label. I can get the info, sorted by store, into a single column, but I’d like multiple columns.
What I would like:
Walmart Safeway Costco
Bread Milk Tofu
I am just starting to learn about Pivot Tables (Excel 2010), and have a question that is probably painfully obvious to you pros - so please bear with me!
In the work sheet, I have a sorted table consisting of 2 columns: Column A contains one of 3 stores, Column B contains merchandise. I would like the Pivot Table to have 3 columns with Column Labels = the 3 stores, and then the merchandise under the column label. I can get the info, sorted by store, into a single column, but I’d like multiple columns.
What I would like:
Walmart Safeway Costco
Bread Milk Tofu
