Group By First Column

Paste TSV from Excel (first row is headers), then group by the first column. Output replaces this box.

Delimiter: auto
Ready.

What this page can do

Group rows by the first column, count unique combinations of the remaining columns, and list those unique pairs. Useful for de-duplicating and summarizing TSV data from spreadsheets.

Expect input

Tab-separated values (TSV) where the first row contains headers and there are at least two columns. Pasted from Excel/Sheets is ideal.

Output

TSV is also rendered as a table for easy inspection. Columns: [First Header], Unique Count, and the remaining headers. Each group's key and count are row-spanned, with one row per unique pair showing the remaining column values.