Spreadsheet: 598632d1542633210-transpose-data-practice
Sheet: Sheet2

s.no | Deal headline | Target | Acquiror | Vendor |  | Deal type | Deal status | Date completed | Deal value
1 | America Online has completed the acquisition of Time Warner | TIME WARNER INC.(OLD) (United States of America) | AMERICA ONLINE INC. (United States of America) | - | TIME WARNER INC.(OLD), a United States of America based, Music publisher company | Acquisition 100% | Completed | 2001-01-11 00:00:00 | 181,950,000,000  USD *
2 | Pfizer and Allergan terminate deal describe as merger | ALLERGAN PLC (Ireland) | PFIZER INC. (United States of America) | - | ALLERGAN PLC, a Ireland based, Pharmaceuticals manufacturer company | Acquisition 100% | Withdrawn | 2016-04-06 00:00:00 | 160,000,000,000  USD *
3 | Verizon completes acquisition of remaining stake in Verizon Wireless from Vodafone | CELLCO PARTNERSHIP INC. (United States of America) | VERIZON COMMUNICATIONS INC. (United States of America) | VODAFONE GROUP PLC (United Kingdom) | CELLCO PARTNERSHIP INC., a United States of America based, Mobile telecommunications operator company | Acquisition increased from 55% to 100% | Completed | 2014-02-21 00:00:00 | 130,000,000,000  USD
4 | AB InBev acquires SABMiller via Newbelco | SABMILLER PLC (United Kingdom) | NEWBELCO SA/NV (Belgium) | VONTOBEL HOLDING AG (Switzerland)
5 | AB InBev terminates initial offer for SABMiller | SABMILLER PLC (United Kingdom) | NEWCO (Belgium) | ALTRIA GROUP INC. (United States of America) | CORVEX MANAGEMENT LP (United States of America) | TIME WARNER INC., a United States of America based, [NAME] and video production services company | Acquisition 100% | Completed | 2018-06-13 00:00:00 | 108,700,000,000  USD
6 | AT&T completes acquisition of Time Warner | TIME WARNER INC. (United States of America) | AT&T INC. (United States of America) | SHAREHOLDERS | WARNER-LAMBERT COMPANY, a United States of America based, Pharmaceuticals manufacturer company | Acquisition 100% | Completed | 2000-06-19 00:00:00 | 90,000,000,000  USD
7 | Pfizer buys Warner-Lambert | WARNER-LAMBERT COMPANY (United States of America) | PFIZER INC. (United States of America) | - | LIBERTY MEDIA [NAME] (United States of America) | TIME WARNER CABLE INC., a United States of America based, Cable television network services provider company | Acquisition 100% | Completed | 2016-05-18 00:00:00 | 78,700,000,000  USD *
8 | Charter Communications acquires Time Warner Cable via CCH I | TIME WARNER CABLE INC. (United States of America) | CCH I LLC (United States of America) | SHAREHOLDERS | KINDER MORGAN INC. (United States of America) | - | KINDER MORGAN ENERGY PARTNERS LP, a United States of America based, Oil and natural gas pipelines operator company | KINDER MORGAN MANAGEMENT LLC, a United States of America based, Pipeline operation management consulting services company | EL PASO PIPELINE PARTNERS LP, a United States of America based, Natural gas pipeline operator company | Acquisition
9 | [NAME] acquires Kinder Morgan Energy, El Paso Pipeline and Kinder Morgan Management | KINDER MORGAN ENERGY PARTNERS LP (United States of America) | KINDER MORGAN MANAGEMENT LLC (United States of America) | EL PASO PIPELINE PARTNERS LP (United States of America) | AT&T BROADBAND LLC, a United States of America based, Cable television services company | Acquisition 100% | Completed | 2002-11-18 00:00:00 | 72,000,000,000  USD
10 | Comcast completes acquisition of AT&T Broadband. | AT&T BROADBAND LLC (United States of America) | COMCAST CORPORATION (United States of America) | AT&T CORPORATION (United States of America) | T ROWE PRICE GROUP INC. (United States of America) | PERSHING SQUARE CAPITAL MANAGEMENT LP (United States of America) | ALLERGAN INC., a United States of America based, Pharmaceuticals manufacturer company | Acquisition 100% | Completed | 2015-03-17 00:00:00
11 | Actavis acquires Allergan | ALLERGAN INC. (United States of America) | ACTAVIS PLC (Ireland) | SHAREHOLDERS | LIBERTY MEDIA [NAME] (United States of America) | TIME WARNER CABLE INC., a United States of America based, Cable television network services provider company | Acquisition 100% | Withdrawn | 2015-04-24 00:00:00 | 68,946,394,000  USD *
12 | Comcast and Time Warner Cable terminate transaction | TIME WARNER CABLE INC. (United States of America) | COMCAST CORPORATION (United States of America) | SHAREHOLDERS | [NAME], a United States of America based, Bank holding company company | Acquisition 100% | Completed | 2008-12-31 00:00:00 | 68,111,985,000  USD *
13 | Wachovia announces settlement of North Carolina lawsuit challenging the acquisition by Wells Fargo | [NAME] (United States of America) | WELLS FARGO & COMPANY INC. (United States of America) | - | [NAME], a United States of America based, Pharmaceutical preparations developer company | Acquisition 100% | Completed | 2009-10-15 00:00:00 | 68,000,000,000  USD *
14 | Pfizer completes acquisition of [NAME] | [NAME] (United States of America) | PFIZER INC. (United States of America) | - | SHAREHOLDERS | PAULSON & COMPANY INC. (United States of America) | DIRECTV LLC, a United States of America based, Digital television programming services provider company | Acquisition 100% | Completed | 2015-07-24 00:00:00
15 | AT&T acquires DIRECTV | DIRECTV LLC (United States of America) | AT&T INC. (United States of America) | BERKSHIRE HATHAWAY INC. (United States of America) | ELLIOTT MANAGEMENT CORPORATION (United States of America) | EMC CORPORATION, a United States of America based, Network storage technology manufacturer company | Acquisition 100% | Completed | 2016-09-07 00:00:00 | 67,000,000,000  USD *
16 | EMC acquired by Dell, Mr [NAME], MSD Capital, Silver Lake and Temasek via Dell Technologies | EMC CORPORATION (United States of America) | DELL TECHNOLOGIES INC. (United States of America) | SHAREHOLDERS | BELLSOUTH CORPORATION, a United States of America based, Data, voice and video communications services company | Acquisition 100% | Completed | 2006-12-29 00:00:00 | 67,000,000,000  USD *
17 | AT&T acquires BellSouth | BELLSOUTH CORPORATION (United States of America) | AT&T INC. (United States of America) | - | GENERAL MOTORS CORPORATION (United States of America) | GENERAL MOTORS CORPORATION'S GOOD ASSETS, a United States of America based, Car manufacturer company | Acquisition 100% | Completed | 2009-07-10 00:00:00 | 66,600,000,000  USD *
18 | Sale of GM's good assets complete | GENERAL MOTORS CORPORATION'S GOOD ASSETS (United States of America) | NGMCO INC. (United States of America) | RECEIVER | WALT DISNEY COMPANY, THE, a United States of America based, Motion picture and video producer company | Acquisition 100% | Withdrawn | 2004-04-28 00:00:00 | 66,040,000,000  USD *
19 | Comcast withdraws offer for Walt Disney | WALT DISNEY COMPANY, THE (United States of America) | COMCAST CORPORATION (United States of America) | - | MONSANTO COMPANY, a United States of America based, Pesticides manufacturer company | Acquisition 100% | Completed | 2018-06-07 00:00:00 | 63,000,000,000  USD *
20 | Bayer completes acquisition of Monsanto | MONSANTO COMPANY (United States of America) | BAYER AG (Germany) | - | EI DU PONT DE NEMOURS & COMPANY, a United States of America based, Organic chemicals manufacturer company | Acquisition 100% | Completed | 2017-09-01 00:00:00 | 61,694,671,000  USD *
21 | Dow Chemical acquires DuPont | EI DU PONT DE NEMOURS & COMPANY (United States of America) | DOW CHEMICAL COMPANY, THE (United States of America) | - | MEDTRONIC INC., a United States of America based, Medical technology manufacturer company | Acquisition 100% | Completed | 2015-01-26 00:00:00 | 60,749,458,000  USD *
22 | Medtronic reincorporates in Ireland via acquisition by Medtronic Holdings | MEDTRONIC INC. (United States of America) | MEDTRONIC HOLDINGS LTD (Ireland) | - | PHARMACIA CORPORATION, a United States of America based, Pharmaceuticals manufacturer company | Acquisition 100% | Completed | 2003-04-16 00:00:00 | 60,000,000,000  USD
23 | Pfizer-Pharmacia deal completed | PHARMACIA CORPORATION (United States of America) | PFIZER INC. (United States of America) | - | FEDERAL NATIONAL MORTGAGE ASSOCIATION, a United States of America based, Mortgage loan securitisation services company | Acquisition unknown stake % | Completed | 2009-09-30 00:00:00 | 60,000,000,000  USD *
24 | US Treasury Department acquires additional preferred shares of Fannie Mae | FEDERAL NATIONAL MORTGAGE ASSOCIATION (United States of America) | US GOVERNMENT (United States of America) | - | AT&T BROADBAND LLC, a United States of America based, Cable television services company | Acquisition 100% - Bid 1 | Withdrawn | 2001-07-08 00:00:00 | 58,000,000,000  USD
25 | Comcast has made an offer to acquire AT&T Broadband from AT&T Corp. | AT&T BROADBAND LLC (United States of America) | COMCAST CORPORATION (United States of America) | AT&T CORPORATION (United States of America) | BANK ONE CORPORATION, a United States of America based, Bank holding company company | Acquisition 100% | Completed | 2004-07-01 00:00:00 | 57,405,397,000  USD *
26 | JP Morgan has acquired Bank One Corporation. | BANK ONE CORPORATION (United States of America) | JP MORGAN (United States of America) | - | OTHER SHAREHOLDERS | GILLETTE COMPANY, THE, a United States of America based, Batteries manufacturer company | Acquisition 100% | Completed | 2005-10-01 00:00:00 | 57,000,000,000  USD *
27 | Procter & Gamble completes acquisition of the Gillette Company | GILLETTE COMPANY, THE (United States of America) | PROCTER & GAMBLE COMPANY, THE (United States of America) | BERKSHIRE HATHAWAY INC. (United States of America)