Merging Two Columns

RockWorks | Datasheet | Columns | Merge

Use this RockWorks Datasheet program to merge the contents of two columns into a single column with a user-declared separator. This is also available in the Borehole Manager as a right-click option.

Menu Options

• Data Columns
  • Input:
    • Column A: Select from this drop-down list the name of the column in the datasheet whose contents are to be merged with "Column B," below.
    • Column B: Select the name of the column in the datasheet to be merged with "Column A," above.
  • Output:
    • Result: Select the name of the column in the main datasheet into which the merged items will be recorded. You may select one of the input columns if you wish. Any existing values in this column will be overwritten.
• Options
  • Separator: Type into this prompt the character(s) to be used to separate the merged values from the two input columns.
  • 
    

Step-by-Step Summary

1. Access the RockWorks Datasheet program tab.
2. Open the data file to be manipulated, if necessary.
3. Click on the Columns menu above the datasheet, and select the Merge option.
4. Enter the requested information, described above.
5. Click theProcess button at the bottom of the window to continue.

The program will list the contents of the two input columns in the selected output column, separated by the specified character(s).

See Also

• Changing Column Titles, Styles, and Units
• 
  

Back to Editing the Datasheet

RockWare home page