•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
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#real-time data collaboration
#real-time collaboration
#master list
#dates
#Excel 365
#due date
#countries
#tasks
#individual rows
#task dates
#description column
#SharePoint
#new sheet