When making two columns in microsoft word 2016 for mac now adjust word count in each column3/15/2023 ![]() 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 |