Forum Discussion
Pivot column transform - occasional column
Morning all As context I have used the group by and pivot transformations to summarise which tracks responses to a survey. My issue arises when a particular column is not constant, for example t...
For the pivot step, replace List.Distinct(...) with {"Value1", "Value2", "Value3", ...}
Replacing each "ValueN" with your values.
Alternativly, you can manually insert any that you are missing by replacing List.Distinct(...) with List.Distinct(... & {"MissingValue1", "MissingValue2", ...})
For the pivot step, replace List.Distinct(...) with {"Value1", "Value2", "Value3", ...}
Replacing each "ValueN" with your values.
Alternativly, you can manually insert any that you are missing by replacing List.Distinct(...) with List.Distinct(... & {"MissingValue1", "MissingValue2", ...})
Legend thank you