You should make sure that the details that you post are accurate. This
is now the third variation that you have posted, and I presume that
you have an Account#10 and Account#11 in sheet1, though this is
omitted.

As before, put these formulae in Sheet 2 in the cells stated:

A2: =INDEX(Sheet1!A:A,INT((ROW(A1)-1)/12)+2)

B2: =INDEX(Sheet1!B:B,INT((ROW(A1)-1)/12)+2)

C2: =INDEX(Sheet1!C:N,INT((ROW(A1)-1)/12)+2,MOD(ROW(A1)-1,12)+1)

Then just copy these down as far as required.

Hope this helps.

Pete


On Aug 24, 4:42*pm, TLC wrote:
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