There are two sample spreadsheets below. The "current" and the "desired"
My real spreadsheet will have 5000 rows.
I work for a baseball team's ticketing office, and i need to scan the barcodes from the tickets of full season ticket holders into this spreadsheet after every game. Each column will be used for 1 game, and contain all the scanned barcodes (a barcode will consist of the section/row/seat)
After scanning the tickets after the game, my spreadsheet looks like the "current" example below, but i want it to look like the desired. The game1 and game2 columns contain all the barcodes that tell me who showed up to that game.
I want to sort the game1 and game2 columns in the "current" example so that the seatID will appear next to the person's name in the row with the same seat ID, as shown in the "Desired" spreadsheet.
In the spreadsheet, Todd is the only person to show up for both games, and i can see that easily because the 2 "9a"'s are next to the his name and his seat for the season (9a) in the "desired" spreadsheet.
I don't know how to sort the game1 and game2 columns so that they can match (and be on the same row as) the value in the second column. I hope someone can follow and help! Thanks
My real spreadsheet will have 5000 rows.
I work for a baseball team's ticketing office, and i need to scan the barcodes from the tickets of full season ticket holders into this spreadsheet after every game. Each column will be used for 1 game, and contain all the scanned barcodes (a barcode will consist of the section/row/seat)
After scanning the tickets after the game, my spreadsheet looks like the "current" example below, but i want it to look like the desired. The game1 and game2 columns contain all the barcodes that tell me who showed up to that game.
I want to sort the game1 and game2 columns in the "current" example so that the seatID will appear next to the person's name in the row with the same seat ID, as shown in the "Desired" spreadsheet.
In the spreadsheet, Todd is the only person to show up for both games, and i can see that easily because the 2 "9a"'s are next to the his name and his seat for the season (9a) in the "desired" spreadsheet.
I don't know how to sort the game1 and game2 columns so that they can match (and be on the same row as) the value in the second column. I hope someone can follow and help! Thanks
attendance spreadsheet.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Current | Desired | |||||||||
2 | Name | Seat | Game1 | Game2 | Name | Seat | Game1 | Game2 | |||
3 | Doug | 1a | 9a | 6a | Doug | 1a | 1a | ||||
4 | Jane | 2a | 12a | 3a | Jane | 2a | 2a | ||||
5 | Bob | 3a | 1a | 9a | Bob | 3a | 3a | ||||
6 | Rick | 4a | 7a | Rick | 4a | ||||||
7 | Tom | 5a | 2a | Tom | 5a | ||||||
8 | Bill | 6a | Bill | 6a | 6a | ||||||
9 | John | 7a | John | 7a | 7a | ||||||
10 | Josh | 8a | Josh | 8a | |||||||
11 | Todd | 9a | Todd | 9a | 9a | 9a | |||||
12 | Matt | 10a | Matt | 10a | |||||||
13 | Cate | 11a | Cate | 11a | 11a | ||||||
14 | Tony | 12a | Tony | 12a | 12a | ||||||
15 | Dave | 13a | Dave | 13a | |||||||
Sheet3 |