convert rows in to columns

[brindlogcool]

I have the log file as below and want to convert the rows into columns. I cannot go with the cross tab because if you look at the user A2 the process started at 11/19/2013 19:48:16  and the finished the process at 11/19/2013 21:10:06.  Any suggestions will be helpful 11/19/2013 17:46:09 Details              User request by A1             11/19/2013 17:46:09 Details Started the Process 09ea98226af2507664ee49371780fb5b 11/19/2013 18:15:36 Details Finished the Process 09ea98226af2507664ee49371780fb5b 11/19/2013 18:17:48 Details User request by A2            11/19/2013 19:48:16 Details Started the Process 09ea98226af2507664ee49371780fb5c 11/19/2013 19:48:16 Details User request by A2          11/19/2013 20:19:58 Details Started the Process 09ea98226af2507664ee49371780fb5c 11/19/2013 20:55:40 Details User request by A1 11/19/2013 20:55:40 Details Started the Process 09ea98226af2507664ee49371780fb5d 11/19/2013 21:10:06 Details Finished the Process 09ea98226af2507664ee49371780fb5d 11/19/2013 21:10:06 Details Finished the Process 09ea98226af2507664ee49371780fb5c

[brindlogcool]

Attached the log file for reference

[agilos_mla]

Try to isolate the valuable data of each record, it seems USER, Timestamp, Step,  Key, then I suggest to use a generic load.

Generic Load (A Manufacturing Example)

Michael

[brindlogcool]

Thanks Michael. I doubt generic load will be helpful.Since there is no unique way to reference the records.