Spreadsheet: 94037d1293822280-moving-data-from-a-row-to-column-based-on-dup-test_data_macro
Sheet: Test_Data_Macro

Company Name | First Name1 | Last Name1 | Title1 | Contact Number1 | Contact Email1 | First Name2 | Last Name2 | Title2 | Contact Number2 | Contact Email2 | First Name3 | Last Name3 | Title3 | Contact Number3 | Contact Email3 | First Name4 | Last Name4 | Title4 | Contact Number4 | Contact Email4 | Primary Address 1 | Primary Address 2 | Primary City | Primary State | [NAME] | Primary Country | Company Number | Toll-Free Number | Company Fax | Web Address | Employees At This Location | Primary Industry | Import Source
Company A | [NAME] | [NAME] | Director |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6109 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 20 | Education | Hoovers
Company A | [NAME] | Shipman | Director |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6109 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Education | Hoovers
Company A | [NAME] | Mance | Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6492 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Hospitality | Hoovers
Company A | [NAME] | [NAME] | President |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6040 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Hospitality | Hoovers
Company A | [NAME] | Rickard | President |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | Michelle | Burnore | IT Manager |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | [NAME] | Rickard | Owner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | [NAME] | Robertshaw | President |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6103 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 25 | Software/Services | Hoovers
Company C | Hector | Torres | President |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Software/Services | Hoovers
Company C | [NAME] | Funtes | Principal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Software/Services | Hoovers
Company C | Christine | Manzi | Staff |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Medical | Hoovers
Company C | [NAME] | Aucoin | Manager |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Medical | Hoovers