Please provide me your inputs to split & get the output from the below data.
5 06/10/2016 Endorse/Revise Add EMT:…Submitted 4/27/2016 06/10/2016
4 06/10/2015 New Auto: …Issued 4/27/2015 06/10/2016
We don’t have any unique value to find and split and it also has spaces in between which is not constant.
Expected Output in below format
5, Endorse/Revise & 4/27/2016
4, New & 4/27/2015