•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Splitting out a master list into individual rows
I have a table that shows a list of countries as rows and tasks as columns. Inside each cell for a particular country and task will be one or more dates of when those tasks are due, separated with commas. I've done this to make the master table easy to read.
Is there an easy way to split those cells out on another sheet with a description column and a due date column?
I've simplified the example - in the real version there are over 100 countries so I needed a way to easily summarise and edit the task dates for future, but have it as individual rows in the new sheet so that I can upload that to sharepoint as a list.
Working on Excel 365
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com