▲ 1 r/googlesheets
Pivot tables: merging columns
I want to create pivot tables that compare survey responses (rows) across age groups (columns). My age data is currently in single years (e.g., 11, 12, 13), but I'd like to combine them into a group (e.g., 11-13)
Is there a way of combining the ages into a single column in Google Sheets?
Thanks.
u/ChoiceApartment2437 — 3 days ago