Registered users can ask their own questions, contribute to discussions, and be part of the Community!
My data looks like this:
And i want it looks like this:
What you aim to achieve here is a Pivot. This operation can be done in a dedicated Pivot, or Prepare recipes. Given we need first to clean the labels records, the latter recipe is the most straightforward option.
The following steps:
will provide the desired output: