A bidirectional transposition performs both row-to-column transposition and column-to-row transposition simultaneously.

Below are sales records grouped by channel:

Desired transposition result:

First, we transpose columns to rows by transforming Online and Store to values of the new Category field.

Then we transpose rows to columns by transforming distinct values under Day field to new column names.

SPL script:

A3 Use pivot@r function to perform column-to-row transposition that uses channel types Online and Store as values of new field Category.
A4 Use pivot() function to perform row-to-column transposition that converts distinct values of Day field to new field names.