Excel SPLIT DELIMITED DATA INTO NEW ROWS

摘要

The member who asked the question receives a new file every day that contains a list of orders that came in through the website. Each order occupies one row in the worksheet. Column C contains a list of products in that order, with each product separated by a semicolon (see Figure 1). The goal is to split the data in column C so that each product occupies a new row in the spreadsheet. All of the data from columns A, B, D, and E would be repeated in the new rows. In other words, rather than simply having each order take up a row, each product ordered would get its own row.