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

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

20200703 - Tranposing.yxmd