Spreadsheet: 165805d1341344572-pasting-data-from-the-web-into-a-spreadsheet-formatting-query-mls-test-2012
Sheet: Sheet1

http://uk.soccerway.com/national/united-states/mls/2012/regular-season/
 |  |  |  |  |  |  | HOME SCORE | AWAY SCORE | HOME TEAM | AWAY TEAM | TEST HOME | TEST AWAY
Sat | 2012-03-10 00:00:00 | Colorado Rapids | 2 - 0 | Columbus Crew | View events | More info | 2 | 0 | Colorado Rapids | Columbus Crew | 32 | 32
 |  | Whitecaps | 2 - 0 | Montreal Impact | View events | More info | 2 | 0 | Whitecaps | Montreal Impact | 32 | 32
Sun | 2012-03-11 00:00:00 | DC United | 0 - 1 | Sporting KC | View events | More info | 0 | 1 | DC United | Sporting KC | 32 | 32
 |  | LA Galaxy | 2012-03-01 00:00:00 | Real Salt Lake | View events | More info | 3 | 7 | LA Galaxy | Real Salt Lake | 32 | 32
 |  | SJ Earthquakes | 1 - 0 | New England | View events | More info | 1 | 0 | SJ Earthquakes | New England | 32 | 32
 |  | Dallas | 2012-01-02 00:00:00 | New York RB | View events | More info | 3 | 8 | Dallas | New York RB | 32 | 32
 |  | Chivas USA | 0 - 1 | Houston Dynamo | View events | More info | 0 | 1 | Chivas USA | Houston Dynamo | 32 | 32
ue | 2012-03-13 00:00:00 | Portland Timbers | 2012-01-03 00:00:00 | Philadelphia Union | View events | More info | 3 | 9 | Portland Timbers | Philadelphia Union | 32 | 32
Sat | 2012-03-17 00:00:00 | Montreal Impact | 2012-01-01 00:00:00 | Chicago Fire | View events | More info | 3 | 7 | Montreal Impact | Chicago Fire | 32 | 32
 |  | SJ Earthquakes | 0 - 1 | Houston Dynamo | View events | More info | 0 | 1 | SJ Earthquakes | Houston Dynamo | 32 | 32
Sun | 2012-03-18 00:00:00 | Sporting KC | 3 - 0 | New England | View events | More info | 3 | 0 | Sporting KC | New England | 32 | 32
 |  | Dallas | 2012-01-01 00:00:00 | Portland Timbers | View events | More info | 3 | 7 | Dallas | Portland Timbers | 32 | 32
 |  | [NAME] | 2012-01-03 00:00:00 | Toronto | View events | More info | 3 | 9 | [NAME] | Toronto | 32 | 32
 |  | Real Salt Lake | 2 - 0 | New York RB | View events | More info | 2 | 0 | Real Salt Lake | New York RB | 32 | 32
 |  | Chivas USA | 0 - 1 | Whitecaps | View events | More info | 0 | 1 | Chivas USA | Whitecaps | 32 | 32
 |  | Philadelphia Union | 2012-02-01 00:00:00 | Colorado Rapids | View events | More info | 3 | 8 | Philadelphia Union | Colorado Rapids | 32 | 32
 |  | LA Galaxy | 2012-01-03 00:00:00 | DC United | View events | More info | 3 | 9 | LA Galaxy | DC United | 32 | 32
Sat | 2012-03-24 00:00:00 | [NAME] | 2 - 0 | Houston Dynamo | View events | More info | 2 | 0 | [NAME] | Houston Dynamo | 32 | 32
 |  | Toronto | 0 - 3 | SJ Earthquakes | View events | More info | 0 | 3 | Toronto | SJ Earthquakes | 32 | 32
 |  | Columbus Crew | 2 - 0 | Montreal Impact | View events | More info | 2 | 0 | Columbus Crew | Montreal Impact | 32 | 32
 |  | New England | 1 - 0 | Portland Timbers | View events | More info | 1 | 0 | New England | Portland Timbers | 32 | 32
Sun | 2012-03-25 00:00:00 | Chicago Fire | 1 - 0 | Philadelphia Union | View events | More info | 1 | 0 | Chicago Fire | Philadelphia Union | 32 | 32
 |  | Real Salt Lake | 0 - 1 | Chivas USA | View events | More info | 0 | 1 | Real Salt Lake | Chivas USA | 32 | 32
 |  | Whitecaps | 0 - 0 | DC United |  | More info | 0 | 0 | Whitecaps | DC United | 32 | 32
 |  | New York RB | 2012-01-04 00:00:00 | Colorado Rapids | View events | More info | 3 | 0 | New York RB | Colorado Rapids | 32 | 32
Mon | 2012-03-26 00:00:00 | Sporting KC | 2012-01-02 00:00:00 | Dallas | View events | More info | 3 | 8 | Sporting KC | Dallas | 32 | 32
Sat | 2012-03-31 00:00:00 | DC United | 2012-01-04 00:00:00 | Dallas |  |  | 3 | 0 | DC United | Dallas | 32 | 32
Sat | 2012-03-31 00:00:00 | Toronto | 0 - 1 | Columbus Crew | View events | More info | 0 | 1 | Toronto | Columbus Crew | 32 | 32
 |  | Philadelphia Union | 0 - 0 | Whitecaps |  | More info | 0 | 0 | Philadelphia Union | Whitecaps | 32 | 32
 |  | New York RB | 2012-02-05 00:00:00 | Montreal Impact | View events | More info | 3 | 2 | New York RB | Montreal Impact | 32 | 32
Sun | 2012-04-01 00:00:00 | [NAME] | 0 - 1 | SJ Earthquakes | View events | More info | 0 | 1 | [NAME] | SJ Earthquakes | 32 | 32
 |  | Portland Timbers | 2012-03-02 00:00:00 | Real Salt Lake | View events | More info | 3 | 8 | Portland Timbers | Real Salt Lake | 32 | 32
 |  | LA Galaxy | 2012-03-01 00:00:00 | New England | View events | More info | 3 | 7 | LA Galaxy | New England | 32 | 32
Mon | 2012-04-02 00:00:00 | Colorado Rapids | 2 - 0 | Chicago Fire | View events | More info | 2 | 0 | Colorado Rapids | Chicago Fire | 32 | 32
 |  | Chivas USA | 0 - 1 | Sporting KC | View events | More info | 0 | 1 | Chivas USA | Sporting KC | 32 | 32
Thu | 2012-04-05 00:00:00 | Real Salt Lake | 1 - 0 | Montreal Impact | View events | More info | 1 | 0 | Real Salt Lake | Montreal Impact | 32 | 32
Fri | 2012-04-06 00:00:00 | Dallas | 1 - 0 | New England | View events | More info | 1 | 0 | Dallas | New England | 32 | 32