Here is an update to my question posted last week:

I have a spreadsheet with close to 700 lines of information on it. The
current format of the spreadsheet is Matrix Data (Row 1 = Date; Location;
Account #1; Account #2; Account #3; Account #4; Account #5; Account # 6;
Account # 7; Account #8; Account #9; Account #12;
Row 2 = 3/1/09; Season Pass Window; $300; $400; $200; $0.00; $100; $200;
$300; $200; $0.00; $100; $200; $300)

I need to copy the data to a tabular format with the following criteria:

Row 1 = Date; Location; Account
Row 2 = 3/1/09; Season Pass; $300
Row 3 = 3/1/09; Season Pass; $400
Row 4 = 3/1/09; Season Pass; $200
Row 5 = 3/1/09; Season Pass; $0.00
Row 6 = 3/1/09; Season Pass; $100
Row 7 = 3/1/09; Season Pass; $200
Row 8 = 3/1/09; Season Pass; $300
Row 9 = 3/1/09; Season Pass; $200
Row 10 = 3/1/09; Season Pass; $0.00
Row 11 = 3/1/09; Season Pass; $100
Row 12 = 3/1/09; Season Pass; $200
Row 13 = 3/1/09; Season Pass; $300

This will repeat for the 700 lines on the original spreadsheet. I figure I
could end up with close to 6000 lines for a month.

I need to know the best way to pull the information from the Matrix Data Set
to the Tabular with out having to change a massive number of formulas. I
have tried a pivot table but could not make it work.

Also is there a formula that would allow me to break out each day on a
separate worksheet? I will not have the same number of lines for each day on
the original spreadsheet. The days may have anywere from 1 to 32 lines per
day. I would like to have a worksheet per day so the 1st may have 10 lines *
12 vs the 2nd day may have 25 lines *12 (12 is the number of accounts that
will be for each line on the original spreadsheet.)

If you need more information please let me know I am willing to email
additional information.

ANy help is greatly appreciated.

--
TC