Google Sheets users wrestle with dynamic data reshaping formulas
Google Sheets users struggle to consolidate and reshape data when source tabs have changing columns, repeated fields, or variable-length results. They resort to slow or difficult-to-maintain formulas and manual edits; some leave blank rows to make room for results that spill into cells below. The requests cover several kinds of data wrangling, so demand for one focused workflow is not yet proven.
For google Sheets users maintaining multi-tab, formula-driven datasets. Mentioned from Jan 2024 to May 2025 on Stack Exchange.
8 different people described this problem in 8 separate discussions.
- Indie fit
- 4.0/10
- Pain
- 4.8/10
- Frequency
- 7.9/10
- Willingness to pay
- 0.0/10
- Momentum
- 5.0/10
- Who pays
- Professionals
- Competition
- Medium
- Build difficulty
- Medium
What people said
Quoted word for word. Follow a link to read the whole discussion.
I have tried using the query function but it seems to be stacking the data by relative column position rather than matching up the column letters. Is there any alternative/option to this?
Rearrange columns in Google Sheets I have data in Google Sheets that I want to rearrange. In each row, starting from the 4th column onwards, there are repeating column pairs of Favorite Fruit # & Favorite Color # where # indicates the index of the pair relative to other pairs.
Build brief
See what to build and who will buy it
- 2 product ideas with the smallest useful version and pricing
- 3 places to find your first customers
- 6 more quotes from people who have this problem
- Current workarounds, existing solutions and risks