Joining many rows into one cell per group
Values from many rows must be joined or concatenated into one cell per group, and the formulas are hard to get right.
Tier I · Proven The best-established problems.
5 public reports · first reported 7 May 2018 · last reported 28 January 2025
What's going wrong
People need several entries that belong to one name, product, or code combined into a single cell, either as a delimited list or with sequence numbers in front of each item.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 5 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.