It’s likely that you’ve been using Excel and have never heard of the Power Query tools. Fortunately, a 2017 update to Power Query now lets you split a column by a delimiter (or by a certain number of characters) and have the results appear in new rows. Writing such a macro would require more than a couple of minutes and some knowledge of VBA instead of relying on the macro recorder. Text to Columns would let you easily split column C into new columns, but transposing those new columns to rows would probably require a VBA macro. In other words, rather than simply having each order take up a row, each product ordered would get its own row. All of the data from columns A, B, D, and E would be repeated in the new rows.

The goal is to split the data in column C so that each product occupies a new row in the spreadsheet. Column C contains a list of products in that order, with each product separated by a semicolon.

Each order occupies one row in the worksheet. The member who asked the question receives a new file every day that contains a list of orders that came in through the website.