In google sheet, is there any way to summarize data that is stored in row to be listed in column?
Here is the dummy link: https://docs.google.com/spreadsheets/d/1w1_p9LdBzFuwozLZwrp04pCs-dyzsZ7e2VlWH1b7_9w/edit?usp=sharing
"transaction" sheet contains the transaction data while "summary" sheet contains the output that I need
Thankyou!!
try:
=ARRAYFORMULA(QUERY(SPLIT(FLATTEN(
IF(transaction!C2:E="",,transaction!B2:B&"×"&transaction!C2:E)), "×"),
"select Col1,Col2,count(Col2)
where Col2 is not null
group by Col1,Col2
label Col1'date',Col2'product',count(Col2)'qty'"))