how to import a excel file including a cell and multi line
Hi, all,
I have an excel file as attached (table1: two rows and three columns). I would like it to read it as table2, as: separate the multiple line in one cell as different rows (7 rows and 4 columns). Is there a quickly way?
You can try tNormalize component, normalize the response column to be multi lines, and then extract fields from the response columns using tExtractDelimitedFields.
