Hi Macropod,

Firstly big thanks for your reply, which I've tried but encountered a problem.

Copied your macro into Word and ran it, the result I got is per below, I've only shown one example.

at_case_id,ca_case_ref,at_created_dt,at_audit_type ,at_audit_note,at_user_id
60615
ca_case_ref LON/00AG/OC6/2014/0001
at_created_dt 2014-09-15 09:01:58
at_audit_type NEWCASE
at_audit_note
at_user_id 56

Saved this as a .csv file, however Excel would not open the file, the error message showing that the file format is not valid. Not sure why as I think I followed it correctly.

I've (hopefully) uploaded a small example of the data in its current state, my original post describes how I ideally need it.

Regards,


Ballst

Attached Files

case_audit_oc6.xls (10.0 KB, 9 views)