I work for a box office that sells tickets to events.
For my full season ticket holders, i wish to track their attendance by scanning in the stub of their ticket for each event.
I envision the first column being the customers name, the second column the unique seat identifier for that person's seat for the entire season. Each additional column will be the scanned in tickets for each game in the season. The barcode would be the same unique seat identifier, and i would be able to match them up visibly by moving the unique identifier to the same row. See example below. There are 5 season ticket holders, the second column is their seat for the season, and the 3rd and 4th column are the scanned barcodes from the first two games. On the first game, Jane and Tom showed up. In the bottom spreadsheet, it is easy to see that Tom is the best attender because his "5a" is easily viewable in the same row. I want the spreadsheet to sort things so that i can turn the top spreadsheet into the bottom, but i don't know how. I'd greatly appreciate any help.
Thanks,
Doug
TOP SPREADSHEET
Doug 1a 2a 4a
Jane 2a 5a 5a
Bob 3a
Rick 4a
Tom 5a
BOTTOM SPREADSHEET
Doug 1a
Jane 2a 2a
Bob 3a
Rick 4a 4a
Tom 5a 5a 5a
For my full season ticket holders, i wish to track their attendance by scanning in the stub of their ticket for each event.
I envision the first column being the customers name, the second column the unique seat identifier for that person's seat for the entire season. Each additional column will be the scanned in tickets for each game in the season. The barcode would be the same unique seat identifier, and i would be able to match them up visibly by moving the unique identifier to the same row. See example below. There are 5 season ticket holders, the second column is their seat for the season, and the 3rd and 4th column are the scanned barcodes from the first two games. On the first game, Jane and Tom showed up. In the bottom spreadsheet, it is easy to see that Tom is the best attender because his "5a" is easily viewable in the same row. I want the spreadsheet to sort things so that i can turn the top spreadsheet into the bottom, but i don't know how. I'd greatly appreciate any help.
Thanks,
Doug
TOP SPREADSHEET
Doug 1a 2a 4a
Jane 2a 5a 5a
Bob 3a
Rick 4a
Tom 5a
BOTTOM SPREADSHEET
Doug 1a
Jane 2a 2a
Bob 3a
Rick 4a 4a
Tom 5a 5a 5a