I have a simple stats
| stats values(Field1) sum(TB) by Field2 date_month
This gives me one row for each month.
Field1 10 Field2 Jan
Field1 15 Field2 Feb
I want to see it like below so each month is on the same row grouped by the fields.
Field1 Field2 Jan 10 Feb 15
Tried transpose and some other suggestions. I just keep missing.