Partial Transposition of a Dataset - Can it be done in the Pipeline Builder?

[VBulator]

Dear Community,

I have a dataset that looks like this (example):

This dataset has the sales numbers for each product displayed in the columns. Now I would like to restructure it so that the region information is in a separate column again, like this:

Does a transform exist in the Pipeline Builder to do this partial transposition or do i have to use the code repo?

I’m looking forward to your suggestions and solutions!

[lrhyne]

Indeed! You’re looking for the unpivot transform.

In your example case, you’d want the Output unpivoted column name to be region and the Unpivoted values output column name to be sales_number and then choose the
North, South, East, West as the Columns to Unpivot.