Need help with transposing and merging rows

[qontrol]

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

[qontrol]

Wow thanks alot @ImkeF, this truly workled like a charm!

[ImkeF · Accepted solution]

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)