All Questions
2 questions
2
votes
2
answers
398
views
Google Sheets - transpose irregular column data in groups into rows
Much like the problem with the transposing of data in transpose column data I am stuck trying to transpose a set of data with multiple variables. The biggest issue I face is trying to remove useless ...
- 35
1
vote
1
answer
71
views
Query particular row + remove X columns + and sum the rest in one formula?
I have a CSV file that I'm pulling from a database. It's in an awkward layout so I need to reorganise it and display the result in a separate sheet.
Here is a dummy example of the data structure I ...
- 503