listing multiple items from a cell into a table

[slamanager]

Hi,

Have the following issue which maybe more of a DB issue. i have been able to download data from audit log for tickets raised. Each ticket varies from 1 row to 20 rows of info, for example col AH has info in it that i need to search for per ticket. The problem is that there are sometimes three items of info i extrcat from the same cell.

How can i table the data so it lists the ticket number then all the pieces of info i have collected so i then can do calcs for durations between events etc.

example sheet
A = ticket numbers T0000001 to TXXXXXXXXX
AH = text of the audit log multiple lines in the one cell

if a tiket is say 5 days in duration from start to end then there is an audit log for any changes in the ticket so in this example say there is 10 changes. On row 1 i gather the start date and the expected end date row two has a text update row three has an assignment update for a member of staff and a team assignment etc etc untill th last row has the close date. All updates have a date and time stamp dd/mm/yyyy hh:mm:ss am/pm

How can i get these multiple into a table showing each input per a row and in order of them happening.

 

[Gerald Higgins]

Well to start with, take a look at the Data, Text to Columns function.
Your data will still be all in one row, but you might be able to split it up into separate cells, if you can identify suitable delimiters.

 

[slamanager]

The issue with that is there are multiple items in the AH column per row also if i had to split it all the data in the AH col doesnt always follow a pattern so if i did spilt it i dont think that would help.

 

[slamanager]

I think i might move this all to access then query each item i need combining it with the audit datestamp to make it unique then deconstructing it so i can calc the durations i require, better get my access hat on and start building.......