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.