Из ввода, как показано ниже:
Last Name First Name Job Title Date Hired Description Field Name Value SSN/Fed ID AL V Assistant 12/08/2008 Driver License Expiration Date 2/23/16 364 AL V Assistant 12/08/2008 expiration date Physical DOT Exp. 09/17/2014 364 AL V Assistant 12/08/2008 Fingerprinting Registered 3/14/13 364 AL V Assistant 12/08/2008 Fingerprinting Received 3/28/13 364 AL V Assistant 12/08/2008 Child Abuse Mailed 3/21/13 364 AL V Assistant 12/08/2008 Child Abuse Received 04/04/2013 364 AL V Assistant 12/08/2008 Annual Cert-Violations 3/9/12 364 AL V Assistant 12/08/2008 MVR Last Ran 3/20/12 364 AL V Assistant 12/08/2008 Driver S Card Exp 364 AL V Assistant 12/08/2008 Driver Recert Due 364 AL V Assistant 12/08/2008 Physical SB Exp. 364 AL V Assistant 12/08/2008 Criminal Received 3/18/13 364 AL V Assistant 12/08/2008 Act 24 12/23/2011 364 AL V Assistant 12/08/2008 Fingerprinting ID # PAE 364 AL V Assistant 12/08/2008 Physical NON-DOT Exp. 364 AL V Assistant 12/08/2008 Fingerprinting Went 3/21/13 364 AL V Assistant 12/08/2008 Fingerprinting Resubmittal 364 BA S Assistant 07/14/2009 Driver License Expiration Date 2/22/2014 190 BA S Assistant 07/14/2009 expiration date Physical DOT Exp. 2/1/14 190 BA S Assistant 07/14/2009 Fingerprinting Registered 6/17/2009 190 BA S Assistant 07/14/2009 Fingerprinting Received 6/25/2009 190 BA S Assistant 07/14/2009 Child Abuse Mailed 2/17/2009 190 BA S Assistant 07/14/2009 Child Abuse Received 2/26/2009 190 BA S Assistant 07/14/2009 Annual Cert-Violations 03/14/2012 190 BA S Assistant 07/14/2009 MVR Last Ran 03/20/2012 190 BA S Assistant 07/14/2009 Driver S Card Exp 190 BA S Assistant 07/14/2009 Driver Recert Due 190 BA S Assistant 07/14/2009 Physical SB Exp. 190 BA S Assistant 07/14/2009 Criminal Received 2/22/13 190 BA S Assistant 07/14/2009 Act 24 12/22/2011 190 BA S Assistant 07/14/2009 Fingerprinting ID # PAE 190 BA S Assistant 07/14/2009 Physical NON-DOT Exp. 190 BA S Assistant 07/14/2009 Fingerprinting Went 6/17/2009 190 BA S Assistant 07/14/2009 Fingerprinting Resubmittal 190
Как я могу объединить строки для результата следующим образом?
Last Name First Name Title DOHire DL Exp Date SS Physical DOT Fingerprint Registered Fingerprint Received Child Abuse Mailed Child Abuse Received Annual Cert MVR last run Driver S Driver Recert Physical SB Criminal Received Act 24 Fingerprinting ID# Physical Non DOT Fingerprinting Went Fingerprint Resubmittal Al V Assistant 12/8/2008 2/23/2016 364 9/17/2012 3/14/2013 3/28/2013 3/21/2013 4/4/2013 3/9/2012 3/20/2013 3/18/2013 12/23/2013 PAE 3/21/2013 Ba S Assistant 7/14/2008 2/22/2014 190 2/1/2014 6/17/2009 6/25/2009 2/17/2009 2/26/2009 3/14/2012 3/20/2012 2/22/2013 12/22/2011 PAE 6/17/2009