How to merge rows and columns in a CSV File - Rons Place Articles

11/19/2018

To Merge Rows in a CSV File

• Using Rons CSV Editor, open or import the CSV file.
• Go to the 'Row/Merge' menu.
• Apply the appropriate settings:
• • Choose 'Selected Rows' or 'All rows'
  • Select the columns sections to be merged
  • Select the separator required
• Click on Merge.
• Save the file.

To Merge Columns in a CSV File

• Using Rons CSV Editor, open or import the CSV file.
• Go to the 'Column/Merge' menu.
• Apply the appropriate settings:
• • Select the columns to be merged and transfer them to the Source Column section.
  • Move the columns up or down according to which information must be displayed first.
  • Decide to keep the source columns by marking or not 'Delete source columns after'.
  • Choose a separator, a tab or a line break if necessary.
  • Choose where the merged column must appear either as a separate new column or replacing an existing column.
• Click on 'Merge'.
• Save the file.