Method to create PIVOT from rows/attr to columns?

Ask for Help
1

I have a table like:

| domain      | type      | value |
|-------------|-----------|-------|
| example.org | measure-1 | True  |
| example.org | measure-2 | False |
| example.net | measure-1 | False |

I would like to make a pivot of this into a new read-only table, as:

| domain      | measure-1 | measure-2 |
|-------------|-----------|-----------|
| example.org | True      | False     |
| example.net | False     | None      |

How can I achieve this? I’m stuck on both how to create the columns automatically, and then how to lookup the data.

2

Don

I don’t think there is a way to do this from within grist (i.e. create a native grist style grist table) - there is a community widget that brings in a javascript pivot table though.

Martyn

3

Here’s an example

image
image1905×942 128 KB