Pivot Data Block

Pivot data transformation is a technique used in data analysis to reorganize or restructure tabular data. It involves selecting key columns that uniquely identify records, choosing pivot columns whose unique values become new columns, and aggregating values if necessary. The result is a new table with a different structure, often making the data more suitable for analysis or reporting. This transformation is commonly applied to convert data between long and wide formats.

Note: this transformation assumes that data block has 3 columns