I need help with a macro or an Excel function that can add some structure a poorly formatted Excel spreadsheet. The spreadsheet is an activity tracker and the author didn't understand that they were supposed to only put 1 activity on a single row. Instead they put multiple activities into a single cell. They also combined seperate types of data such as dates and types into a single cell. This is frustrating because the data is useless in its current form.
1. How do I build multiple rows of data based on a single multi-line cell?
2. For each of these new rows how do I parse out a date from an Activty type? The author combined these.
There are about 1000 lines of data. So if I have to format this thing manually, it will be a killer. The attached spreadsheet has 2 tabs (Given, and Needed)
Is there an easy way to accomplish this with a VBA script or excel funtion? Examples?