Help with formatting a csv file

Shell Programming and Scripting
1

Hi,

Can anyone help me format a csv file. My csv file have 6 columns. the last 2 columns were put on the second row.
Here is the sample output:
000584, 200829014,30,PAPER,
4200059000,'DIXIE BOWLS HEAVY DUTY DISPOSABLE 10 OZ

  1. How can I put the last 2 columns in the first row, and how will I remove special characters and spaces?
  2. How will I insert the column names?
  3. And I need to add extra text below the file?
    My csv file have at leat 15K rows.

Please help. Thank you in advance.

2

Can you explain what you have so far, and what you're having trouble with?

Regards