![]() These tools were originally written as a crutch for SQL Server pros who were forced to use Excel as a front end to Power Pivot. They were introduced after Excel 2013 shipped as a Microsoft Add-in for Windows versions of Excel 2010 and Excel 2013. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |