Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Use the macro found here to split the volume, number, and date information into three separate columns.
  2. Process the other error an warning messages normally, except for the package name error.
  3. Apply the following procedure to the Oxford Journals Archive Collection and Oxford Journals Collection columns:
    1. Use Edit Column>Split into Several Columns feature to separate multiple collection names. The separator is a plus sign "+".
    2. Create a text facet for each column, including the new ones you've just created.
    3. Rename each cell to the appropriate package name using the faceted values.
  4. Rearrange your columns so that all of the columns you've created are next to each other and at the right-most end of the spreadsheet.
  5. Using the menu for any one of these columns, select Transpose>Transpose columns across rows.
  6. In the "From" column, select the first of your package name columns.
  7. In the "To" column, select the last of your package name columns.
  8. Choose the radio button for "One column" and enter "package.name" as the column name. Check the "Fill down" box.
  9. Click "Transpose"
  10. This will create a new row for each title each time it appears in a different package.