Spreadsheet: 838801d1691418143-line-breaks-in-cells-transposing-information-excel-example-mst
Sheet: Sheet1

Part number | For Vehicle | Text to [NAME]
MST-AD-A101 | [NAME] (8X) - 1.4 TFSI (EA111 - Single Turbo) – 2010 to 2015 Seat Toledo (KG) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015 Skoda Rapid (NH) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015 | [NAME] (8X) - 1.4 TFSI (EA111 - Single Turbo) – 2010 to 2015 | Seat Toledo (KG) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015 | Skoda Rapid (NH) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A103 | [NAME] (8X) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015 [NAME] (6J/6P) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015 Seat Toledo (KG) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015 Skoda Rapid (NH) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015 [NAME] (6R/6C) - 1.2 TSI (EA111 - Single Turbo) – 2011 to 2015 | [NAME] (8X) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015 | [NAME] (6J/6P) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015 | Seat Toledo (KG) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015 | Skoda Rapid (NH) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015 | [NAME] (6R/6C) - 1.2 TSI (EA111 - Single Turbo) – 2011 to 2015
MST-AD-A401 | [NAME] (B8) – 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 Audi A4 (B8) – 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 Audi A5 (8T) - 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 Audi A5 (8T) - 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 | [NAME] (B8) – 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 | [NAME] (B8) – 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 | [NAME] (8T) - 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012 | [NAME] (8T) - 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
Result required :
MST-AD-A101 | [NAME] (8X) - 1.4 TFSI (EA111 - Single Turbo) – 2010 to 2015
MST-AD-A101 | Seat Toledo (KG) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A101 | Skoda Rapid (NH) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A103 | [NAME] (8X) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015
MST-AD-A103 | [NAME] (6J/6P) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015
MST-AD-A103 | Seat Toledo (KG) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A103 | Skoda Rapid (NH) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A103 | [NAME] (6R/6C) - 1.2 TSI (EA111 - Single Turbo) – 2011 to 2015
MST-AD-A401 | [NAME] (B8) – 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
MST-AD-A401 | [NAME] (B8) – 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
MST-AD-A401 | [NAME] (8T) - 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
MST-AD-A401 | [NAME] (8T) - 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
OR can even work like this  :
MST-AD-A101 | [NAME] (8X) - 1.4 TFSI (EA111 - Single Turbo) – 2010 to 2015
 | Seat Toledo (KG) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015
 | Skoda Rapid (NH) - 1.4 TFSI (EA111 - Single Turbo) – 2012 to 2015
MST-AD-A103 | [NAME] (8X) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015
 | [NAME] (6J/6P) - 1.2 TFSI (EA111 - Single Turbo) – 2010 to 2015
 | Seat Toledo (KG) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015
 | Skoda Rapid (NH) - 1.2 TFSI (EA111 - Single Turbo) – 2012 to 2015
 | [NAME] (6R/6C) - 1.2 TSI (EA111 - Single Turbo) – 2011 to 2015
MST-AD-A401 | [NAME] (B8) – 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
 | [NAME] (B8) – 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
 | [NAME] (8T) - 1.8 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012
 | [NAME] (8T) - 2.0 TFSI (EA888 Gen 1 & Gen 2 – with MAF Sensor) – 2008 to 2012