Converting an excel table to a "databaselike" format

Question

I have a table for soccer data in the following format:

http://www.karpi.com/excel.jpg

I would like to convert this data to one tab where I have each game like this:

game date TEAM A TEAM B 3 1 Name 1 Name 2 Name 3 Name 4 Name 5 Name 6 Name 7 Name 8 Name 9 Name 10 Name 11

and another tab where I have

game date TEAM A TEAM B 3 1 Name 10 2 goals Name 11 1 goal

is this something that could be done in Excel or needs a VB script?