I want another tab to rearrange my input. Each corresponding cell (seat) will be a row. Then that cell's value in each table follows. So if I choose to put each table in a new tab, with the first seat being in A1 every time, I want to track A1's value through each table (stunt for the show).
Can pivot tables help me rearrange? Right now I'm using references like =A1 to help, but consecutive seats are columns in the tables, whereas my new output will have one seat per row.
So to summarize, I have tables showing the same layout over different points in time, and I want to see each corresponding cell's value through time.
Edited by Ryan12, 18 September 2011 - 12:41 PM.