1 · Add your data
CSV or Excel · Large XLSX support · Exactly one worksheet · Headers in row 1
Keep only one worksheet (including hidden sheets). Row 1 must contain a unique header for every data column; remove report titles and blank rows above the headers. Excel tables are supported through their worksheet cells. Files are processed in your browser. Excel and CSV support are embedded and work offline.
Auto-fill visit details
Fill empty cells from the preceding row within the same visit. Each nonempty Visit ID starts a fresh block, even when the ID repeats. Existing values are preserved.
Drug Codes is selected when available to skip price-only totals rows. Choose the visit-level fields below; medication fields are not selected automatically.
Upload a file to use either tool.
2 · Choose columns
Group by
Matching identifiers become one row.
Combine values from
Select values to collect for each group.
3 · Configure output
Blank values are skipped; zero is retained. Only group keys and combined columns appear in the output. Values follow source order.
Grouped result
Filter your data
Filter the uploaded rows, including applied auto-fill changes. All original columns are retained. This does not filter the grouped result.
Text comparisons ignore surrounding spaces. Numeric comparisons accept decimal numbers without currency symbols or thousands separators. Blank and nonnumeric cells do not match numeric rules. With no rules, all rows are included.
Filtered result
No rows match these filters. Adjust or clear the filters and apply again.
Large-file processing
Rows are stored locally in this browser. Keep this tab open. Data is not uploaded to a server. Large files require free disk space; use current Chrome or Edge. CSV export is used for large results to keep memory usage bounded.