Forum Discussion

qontrol's avatar
qontrol
New Member
4 years ago
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:

 

 

So basically I want it to transpose the feature rows to new headers called Feature 1/2/3/4 and combine the values in row "FeatureTitle" and "FeatureDesc".

 

I know how to merge multiple rows to one cell, but the P/F column is not helping me.

 

Thank you all for your feedback!

 

Regards

 

Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    Hi qontrol ,
    you should be able to do this with pivot transformations:

    1. Delete empty rows in column "FeatureTitle"
    2. Create a new column that combines column "FeatureTitle" and "FeatureDescription"
    3. Delete column "FeatureDescription"
    4. Pivot column "FeatureTitle" with the newly created column from 2. as values (without aggregation)

2 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    4 years ago

    Hi qontrol ,
    you should be able to do this with pivot transformations:

    1. Delete empty rows in column "FeatureTitle"
    2. Create a new column that combines column "FeatureTitle" and "FeatureDescription"
    3. Delete column "FeatureDescription"
    4. Pivot column "FeatureTitle" with the newly created column from 2. as values (without aggregation)