Search code examples
google-sheetsgoogle-sheets-formulagoogle-sheets-query

Google Sheets Query function sort

I am trying to sort some deposits, I have a list of Dates in Column A, Payment methods in column B, and Amounts in column C.

I need to create a query that can give me Column A "Dates", Column B "Cash Amounts", Column C "Card Amounts", and Column D "Paypal".

Here is a screenshot showing expected results. The columns A:C, are what I have. The columns in blue E:H are what I would like the query to display.

0

Solution

  • you can try it like this:

    =QUERY(A1:C6, "select A,sum(C) where A is not null group by A pivot B", 1)

    0