If columns are months, how to make separate rows for each month?

**piblondin** · 05-19-2011, 03:30 PM

Here's the generic setup: a spreadsheet with different products in the left column and quantity sold in the columns to the right with the month advancing with each column. So, the headers would look like this:

Product,JanuaryQuantity,FebruaryQuantity, etc.

Let's say that we have a sporting goods store for the example. I want to change the format so there are three columns: Product,Month,Quantity.

So, for example, there would now be rows like this:

Baseballs,January,10
Baseballs,February,15
Basketballs,January,10
etc.

How do I transform a spreadsheet like the one I initially mentioned into one like this? It seems to be beyond the functionality of Pivot Tables, but I may be wrong.

**piblondin** · 05-20-2011, 02:14 PM

Can anyone help with this?

**ChemistB** · 05-20-2011, 02:28 PM

I can do this on Windows based but don't know how that transfers to MAC. :/

Does MAC have a "Pivot Table Wizard"?

**piblondin** · 05-20-2011, 04:46 PM

I have the Pivot Table Builder in Excel for Mac. I also have Excel for Windows, so you can explain to me the process for doing it there. Thanks in advance!

**ChemistB** · 05-23-2011, 09:15 AM

Using the Pivot Table Wizard, create a pivottable from your new column to the right using "Multiple Consolidation Ranges", "I will create page fields", add your range, Finish
Part 2: Uncheck "Row" and "Column" leaving a very small pivot table (see example Sheet 4). Double click on the Value (i.e. 73) creating a normalized list (sheet5). Change the headers on the normalized list.

Now you can make your pivot table. Any questions?