Purpose:
Data files downloaded from PETDB and GEOROC are sometimes listed as individual rows sorted by publication or analytical method. A single sample then usually occupies more than one row. To manually combine all rows of one sample into a single row is very time-consuming.

The PetroPlot Compile Rows function automates this task by picking the first value of an element for one sample into a single row in a new sheet. If multiple values exist for that element, the result cell will be marked with an indicative color.

Here we present an example

Start: Open PetroPlotExampleData.xls in Excel.
Activate the "PETDBdownload" worksheet.
There is no need to select any range. This PetroPlot function works on the whole sheet.

Click PetroPlot --> Compile Rows.



Confirmation window, click "YES"

Result: