Normalize your data using the PivotTable Wizard

The Dilema

You have a sheet set up something like this...
[tt]
Acct Jan Feb Mar
Acct01 234 123 567
Acct02 345 234 678
Acct03 456 345 789
[/tt]
and you're having problems doing the stuff to it that you'd like to do.

That's because your data is NOT NORMALIZED. You might want to check out this EXCELLENT link [link http://www.abcdataworks.com/FundamentalsOfRelationalDatabaseDesign.doc]'Fundamentals Of Relational Database Design'[/link]

Excel's PivotTable Wizard to the RESCUE!

1) Start the wizard -- Data/PivotTable & PivotChart Report...

2) Step 1 of 3 - Select Option Button: Multiple Consolidation Ranges -- [Next]

3) Step 2a of 3 - Select Option Button: I will create the page fields -- [Next]

4) Step 2b of 3 - With your cursor in the Range Textbox, select the data range on your sheet that you want to normalize -- [Add] -- [Next]

5) Step 3 of 3 - [Layout...]

6) Drag the Row and Column buttons OFF the Layout -- [OK] -- [Finish]

7) Mysteriously, you are on another sheet that has a 4-cell pivot table. Double click the BOTTOM RIGHT CELL

8) Again, on another sheet -- This is you data normalized, or at least closer to it. You'll need to change headings at least.
[tt]
Row Column Value
Acct01 Jan 234
Acct01 Feb 123
Acct01 Mar 567
Acct02 Jan 345
Acct02 Feb 234
Acct02 Mar 678
Acct03 Jan 456
Acct03 Feb 345
Acct03 Mar 789
[/tt]