Merging monthly exports into one table
Stacking files whose columns do not quite match, and keeping track of which row came from where.
Twelve monthly exports rarely have identical columns. Someone renamed Email to E-mail in March, a new Region column appeared in June. Copy-pasting them under each other shifts data into the wrong columns without any error.
Line columns up by name, not by position
GridRinse merges by header name. The result has every column that appears in any file; rows from a file without that column get an empty cell, and a warning says which files were missing which columns.
Small differences in headers
With Match headers that differ only in case or punctuation on, E-mail, email and EMAIL become one column. Real renames (Full Name vs Name) need you: open Column matching and point each source column at the right target, or choose leave out.
Keep the source
Tick Add a column with the source file name so every row remembers which file it came from. It is invaluable when one month turns out to be wrong.
Clean after merging
The cleaning steps run on the merged table, so duplicates across files (the same order in the January and February exports) are found too. To clean files separately with the same steps instead, choose Batch.