How to use Column Value as header in Query in google sheet
zongshita
I was trying use query to show results as below. But I couldn't figure out how to use Column A (months) as a header.
I knew how to use Vlook or Filter function to generate same results. Since my data is huge, I prefer to use Query function to keep my data flexible. Thank you for helping.
https://docs.google.com/spreadsheets/d/1ljrMdM4m0YT35EP7HxY-Gdj9SrEv6DHoQw_qL8Z9c-Y/edit?usp=sharing
Yoyó
Something like this should work, needs tweaking with ordering though.
=query(Sheet1!A1:C71,"select B, sum(C) group by B pivot A")
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
TOP Ranking
- 1
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 2
pump.io port in URL
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
Unable to use switch toggle for dark mode in material-ui
- 5
grouping by column variables and appending a new variable based on condition
- 6
BigQuery - concatenate ignoring NULL
- 7
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 8
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 9
Python Read Directory And Output to CSV
- 10
Remove adjacent duplicates in linked list in C
- 11
Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use
- 12
How to keep curl session alive between two php processes?
- 13
Limit number of characters in uitextview
- 14
JMeter: Why get error when try to save test plan
- 15
Always setting the text cursor on Textbox
- 16
MTKView Displaying Wide Gamut P3 Colorspace
- 17
Vector input in shiny R and then use it
- 18
How to implement an authentication method using Spring Boot and JPA?
- 19
Laravel getting value from another table using eloquent
- 20
org.springframework.web.client.HttpClientErrorException: 401 null
- 21
When I click any button in my view page the form is submitted
Comments