Hi all,
I have the following data:
companyID, notesPageNum, notes1, notes2
1,1,"Notes Paragraph one","Notes Paragraph two"
1,2,"Notes Paragraph three","Notes Paragraph four"
1,3,"Notes Paragraph five","Notes Paragraph six"
2,1,"Notes Paragraph one","Notes Paragraph two"
2,2,"Notes Paragraph three","Notes Paragraph four"
2,3,"Notes Paragraph five","Notes Paragraph six"
2,4,"Notes Paragraph seven","Notes Paragraph eight"
2,5,"Notes Paragraph nine","Notes Paragraph ten"
3,1,"Notes Paragraph one","Notes Paragraph two"
3,2,"Notes Paragraph three","Notes Paragraph four"
3,3,"Notes Paragraph five","Notes Paragraph six"
I want to merge all of this 11 lines to get just one line, may somebody help me please?
I want to get something like this:
1,1, 1,2, 1,3, .."Notes Paragraph one, Notes Paragraph three, Notes Paragraph five..","Notes Paragraph two, Notes Paragraph four, Notes Paragr.."
Thanks,