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

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.

 

 

Merge Rows

 

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.

 

 

Merge Columns


Tags: Rons CSV Editor

Related Posts