Split text lines in a cell into a new rows; split text lines into columns
RK Rishikesh Sinha
I have a spreadsheet, where customers place order of books. When the customer makes the payment, column N is updated with the amount paid. Changes are made with other columns of the spreadsheet in a row.
I wish to create a new spreadsheet. Its purpose is to list down name of books with respective customer's information. The list is taken to market and books are bought.
Watch row 11 and row 12. Customers has paid the amount and it is noted down in Column N.
Cell B11 and B12 list down list of books partitioned with "/".
The final list looks like this.
(a) with the splitting of lines into new rows
(b) split each line partitioned by '/' into new columns entries.
Thanks and regards,