Sorting column so values move next to like values in 2nd col

[duglazz]

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

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

 

[FryerTuck]

A simple solution:
Scan the barcodes into another (unused) column (in my sample, I used column "E"

In the game column, I copied the following formula into all cells:


=IF(ISERROR(MATCH(B2,$E$2:$E$15,0)),"",B2)

If there is a perfect match between the seat number and any of the barcode date, the seat number will show, otherwise you will get a blank. Just make sure you copy the info as a value rather than a formula before you put the next set of barcodes into column E.

Home Run?