I have a CSV file with two columns namely column 1: file name column 2: access status
The following are some sample recotds
FileA, CREATE FileA, MODIFY FileA, DELETE FileB, CREATE FileB, MODIFY
I need to TRANSPOSE values of the second column into a single row based on the distinct values of the first column.
FileA, CREATE|MODIFY|DELETE FileB, CREATE|MODIFY