For the attached spreadsheet, I need to do 2 things to be able to import each row into another spreadsheet
1. On the "articles" tab, for each part number in column A I need all the text in column B to be in 1 box but maintain the rows of text (like in a memo field) it can't all run together it must stay in rows within the cell . It has to be in one cell for the import.
2. The single cell of text from above needs to be copied into the "allparts" spreadsheet into a new column with the corresponding matching part number. This could be inserted into a new column C right next to column B "EN"