Solved: transpose dinamic column table

Anonymous · ‎11-10-2022

Hi, I have a table like this :

and I need this output :

How could it be done? I tried with dynamic column, but I m getting one line per value full of null values...

PaulDBrown · ‎11-10-2022

You need to pivot the AttributeType column and select no aggregation on TextValue:

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

PaulDBrown · ‎11-10-2022

You need to pivot the AttributeType column and select no aggregation on TextValue:

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

transpose dinamic column table