I have an input CSV file that looks like this:
john,Hello my name john,is John katie,Whereas my katie,name is Katie bob,And I am Bob.
The file is ordered such that names (in the first column) are contiguous, and text (the second column) is ordered logically.
Is there a standardized way to "group by" (using SQL terminology) the first column and concatenate the second column?
My desired output is:
john,Hello my name is John katie,Whereas my name is Katie bob,And I am Bob.