Spreadsheet: 57918d1258131867-extracting-multiple-row-data-from-a-table-testproblemtable
Sheet: Sheet1

 | ORIGINAL DATA |  |  |  |  |  |  |  | DESIRED RESULT
 |  |  |  |  |  |  |  |  |  |  | Country Code
 | Country Code | City Code | Destination | Effective Date | Curr | Rate Per Minute |  | Type Country Code here |  |  | 93
 | 672 | 12 | [NAME] | 01/11/2009 | US$ | 0.8494
 | 672 | 672 | [NAME] | 01/11/2009 | US$ | 0.8494 |  | Get the result table below
 | 672 | 10 | [NAME] | 01/11/2009 | US$ | 0.8494
 | 672 | 13 | [NAME] | 01/11/2009 | US$ | 0.8494 |  | Country Code | City Code | Destination | Effective Date | Curr | Rate Per Minute
 | 672 | 11 | [NAME] | 01/11/2009 | US$ | 0.8494 |  | 93 |  | AFGHANISTAN | 01/11/2009 | US$ | 0.1899
 | 672 | 3 | A.E.T.-Norfolk Islands | 01/11/2009 | US$ | 0.94 |  | 93 | 20 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 672 | 8 | A.E.T.-Norfolk Islands | 01/11/2009 | US$ | 0.94 |  | 93 | 21 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 |  | AFGHANISTAN | 01/11/2009 | US$ | 0.1899 |  | 93 | 22 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 20 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 23 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 21 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 24 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 22 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 25 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 23 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 26 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 24 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 27 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 25 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 28 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846
 | 93 | 26 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 77 | AFGHANISTAN-Mobile Areeba | 01/11/2009 | US$ | 0.2195
 | 93 | 27 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 78 | AFGHANISTAN-Mobile ETISALAT | 01/11/2009 | US$ | 0.2163
 | 93 | 28 | AFGHANISTAN-Kabul | 01/11/2009 | US$ | 0.1846 |  | 93 | 70 | AFGHANISTAN-Mobile Other | 01/11/2009 | US$ | 0.1805
 | 93 | 77 | AFGHANISTAN-Mobile Areeba | 01/11/2009 | US$ | 0.2195 |  | 93 | 75 | AFGHANISTAN-Mobile Other | 01/11/2009 | US$ | 0.1805
 | 93 | 78 | AFGHANISTAN-Mobile ETISALAT | 01/11/2009 | US$ | 0.2163 |  | 93 | 79 | AFGHANISTAN-Mobile Roshan | 01/11/2009 | US$ | 0.201
 | 93 | 70 | AFGHANISTAN-Mobile Other | 01/11/2009 | US$ | 0.1805
 | 93 | 75 | AFGHANISTAN-Mobile Other | 01/11/2009 | US$ | 0.1805
 | 93 | 79 | AFGHANISTAN-Mobile Roshan | 01/11/2009 | US$ | 0.201
 | 355 |  | ALBANIA | 01/11/2009 | US$ | 0.0523
 | 355 | 68 | ALBANIA-Mobile AMC | 01/11/2009 | US$ | 0.2405
 | 355 | 67 | ALBANIA-Mobile Other | 01/11/2009 | US$ | 0.2282
 | 355 | 69 | ALBANIA-Mobile Vodafone | 01/11/2009 | US$ | 0.2364
 | 355 | 4 | ALBANIA-Tirana fixed | 01/11/2009 | US$ | 0.0264
 | 213 |  | ALGERIA | 01/11/2009 | US$ | 0.0585
 | 213 | 21 | ALGERIA-Algiers II | 01/11/2009 | US$ | 0.056
 | 213 | 77 | ALGERIA-Mobile Orascom | 01/11/2009 | US$ | 0.1356
 | 213 | 79 | ALGERIA-Mobile Orascom | 01/11/2009 | US$ | 0.1356
 | 213 | 66 | ALGERIA-Mobile Other | 01/11/2009 | US$ | 0.1053
 | 213 | 69 | ALGERIA-Mobile Other | 01/11/2009 | US$ | 0.1053
 | 213 | 9619 | ALGERIA-Mobile Other | 01/11/2009 | US$ | 0.1053
 | 213 | 55 | ALGERIA-Mobile Wataniya | 01/11/2009 | US$ | 0.2234