I need to transpose/pivot a CSV file. Don't know if that is possibleSuppose this CSV file content:filename;rating;id;summaryS4348gjO.doc;good;0001;describing how to reach your goalsS4348gjO.doc;good;0002;some recipes for avoiding an argumentS4348gjO.doc;bad;0003;boring part of the pageA234HK.doc;fairly good;0001;how to deploy a serverA234HK.doc;bad;0002;start and stop the serverOutput must be:filename;good;fairly good;bad;idS4348gjO.doc;describing how to reach your goals; ; ;0001S4348gjO.doc;some recipes for avoiding an argument; ; ;0002S4348gjO.doc; ; ;boring part of the page;0003A234HK.doc; ;how to deploy a server; ;0001A234HK.doc; ; ;start and stop the server;0002
transpose/pivot csv text file
text processing;csv