Combine Sheets v1.7

Select columns to combine

You can now select specific columns to combine. Either let the add-on auto-detect common columns across the sheets or pick the desired columns manually for a tailored combination.

Add sheet names in the result

Optionally, have sheet names in a new column to the right of your result table so you always know where each piece of data came from.

Separate combined ranges with sheet names

For clearer organization, you can also separate the combined ranges with the sheet and file names, making it easier to identify the origin of your data.

Pull notes to the result

Now, when combining sheets, the add-on will also pull notes associated with cells into the result, ensuring no important information is left behind.

Inherit more original formatting

When combining as values, the result will inherit more formatting of the original cells:

• vertical alignment
• column width
• row height
• wrapping
• data validation

All to make sure that your combined data retains the looks of the source sheets.