A common request is to split the date dimension to columns and show a date in each column.
Setting this up in SyncWith for Google Sheets is easy. You can do it right in the report configuration without needing to use a pivot table.
First setup the report as you normally would, selecting the dimensions and metrics you'd like to see. In this example we've added Day, Click, CTR, and Impressions:
Next, select your pivot dimension. Here we've chosen the Day:
Optionally, apply a sort to the pivot dimension
Run the report and you'll see the days as columns and the metrics as rows:
Limitations
You can only pivot a maximum of 1500 values to columns. If you select columns with more than 1500 values, only the first 1500 values will be shown. If you apply as sort to the report, the first 1500 values using that sort are displayed.