I have been given lists from various sources of Zoom courses and activities I could take part in while in lock down. I have initially had to extract this information from PDF files and copy into a Excel worksheet.
The problem I have is that nothing is in date / time order but just blocks of information in rows where the header row for each block is in the format dd/mm/yyyy,hh:mm-hh:mm where hh:mm is the start and end time of the course.
So as in the attached example I need to be able to sort on the line containing the date / time etc. but keeping the information in the rows below that together. Everything is in Column A. The Title is always in one row. The Zoom ID is always in one row. The Zoom password is always in one row. The Notes though can be over a various number of rows.
This is a one off task but it's a very long list.
Is there a way of fairly easily doing this or would it need a macro?
Any help appreciated.
The problem I have is that nothing is in date / time order but just blocks of information in rows where the header row for each block is in the format dd/mm/yyyy,hh:mm-hh:mm where hh:mm is the start and end time of the course.
So as in the attached example I need to be able to sort on the line containing the date / time etc. but keeping the information in the rows below that together. Everything is in Column A. The Title is always in one row. The Zoom ID is always in one row. The Zoom password is always in one row. The Notes though can be over a various number of rows.
This is a one off task but it's a very long list.
Is there a way of fairly easily doing this or would it need a macro?
Any help appreciated.