Transpose multiple rows when i meet a specific value in one column

[Anastasio_Theohari]

Hello,

I would like to transpose data when i meet a specific value in my data...

For examle lets say i have this data set below : 

The desire output will be like this :

I have tried transpose component based on the first column,but when i meet again the value 'points',i have a conflict there..

Any idea how can i implement this?

[Jonathan-Sherman · Accepted solution]

Hi @Anastasio_Theohari,

You could filter out rows not necessary before transposing:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan