With the formulas now replaced by their last calculated results, Sort the table (ascending) on the index column: When the index has been calculated, select the whole index column, Copy, then go Edit > Paste Formula results. The index values are different as there are more distinct rows in that table, including two of the three rows containing 3434 in column D. On the right hand table, the same formula, referencing the cells of column E, is placed in F2, and filled down to the end of that column.Ĭolumn E contains this formula, entered in E2 and filled down the rest of that column: The index is created by the formula shown below the left hand table, entered in E2, then filled down to the end of that column. Here are two small examples, one using each method to create the same index.įor the table on the left, any of the four columns could be used to create the index.įor the table on the right, no single column can be used to create an index that will mark the first occurence of each distinct row, but a 'whole row' column can be added for this purpose. If such a column does not exist, you can add a second temporary column to hold the concatenated contents of all cells in each row, and use that column. If there is one column in the merged table for which each distinct value is shared by ONLY one set of duplicate rows, you can use that column to generate an index column on which you can sort the data. SGIII, VikingOSX, and a few others are the experts in scripting here, and may be able to provide one that can do the job with less personal interaction.Īdd a temporary 'index' column on which you can sort the table to bring all of the distinct (non-duplicated) rows into a single group, and the second (or later) occurrence of these rows into a separate group. The external process will vary, depending on the script(s) used.

Select all cells in a source table except the cells in a header row (assuming header rows contain identical labels on all tables.Ĭlick once on the cell in the last row of column A, press option-down arrow to add a row.Ĭlick once on the empty cell in column A of the new last row. If the structure of ALL of the tables is the same-same number of columns, placed in the same order-then Copy and Paste is pretty simple, if tedious for a large number of documents.

Two options are: Copy and Paste OR Use a script. You asked 'How do you merge multiple files/documents into one file?'īut you apparently meant 'How do you merge multiple tables on separate files/documents into one table in a single file? ' This doesn't work - just creates a separate sheet'

Group tables numbers for mac