Pivoting Data

Created by Roanne Jane Jane Jaype, Modified on Wed, 10 Aug, 2022 at 3:27 PM by Roanne Jane Jane Jaype

You can also pivot your sheet to extract deper information with the /pivot/<Column Names> suffix.

There are also the _columns and _agg querystring parameters to help you pivot data.

Parameter	Description
_columns	Will split your pivoted groups using these columns
_agg	The type of aggregation that your table will be pivoted into, these are the sames types as seen on Aggregating Data.

Pivot Name, Aggregating by Max

Pivot Name and Age, Aggregating by Max

_______________

Shell

curl 'https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/pivot/Name?_agg=max'

Python

import requests

requests.get('https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/pivot/Name?_agg=max')

Javascript

fetch(
  "https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/pivot/Name?_agg=max"
);