Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Rearranging but not summarizing table data


  • Please log in to reply
No replies to this topic

#1 Ryan12

Ryan12

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Local time:06:30 PM

Posted 18 September 2011 - 12:39 PM

I have a series of tables representing the same stadium seat layout, so some rows have more cells (seats) than others. One cell in a table has an instruction for one seat, e.g. a color for stunt #n of a card show, with the next table being the next instruction, stunt #n+1

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.


BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users