Forum Discussion
Solved
Need help with transposing and merging rows
Hello everyone I'm having issues with a query to transpose rows but also combining them into one cell. Here's my table now: This is how I want it to look after the query: ...
Hi qontrol ,
you should be able to do this with pivot transformations:- Delete empty rows in column "FeatureTitle"
- Create a new column that combines column "FeatureTitle" and "FeatureDescription"
- Delete column "FeatureDescription"
- Pivot column "FeatureTitle" with the newly created column from 2. as values (without aggregation)
Hi qontrol ,
you should be able to do this with pivot transformations:
- Delete empty rows in column "FeatureTitle"
- Create a new column that combines column "FeatureTitle" and "FeatureDescription"
- Delete column "FeatureDescription"
- Pivot column "FeatureTitle" with the newly created column from 2. as values (without aggregation)