Pivot table with multiple values

[webportal]

Hello,

I need to convert this table:

question_text	answer	id_event
ABC	OPL	1
GHI	UIL	1
DEF	LLK	1

Into:

id_event	ABC	GHI	DEF
1	OPL	UIL	LLK

I have tried:

 Table.Pivot(#"Previous Step", List.Distinct(#"Previous Step"[question_text]), "question_text", "answer")

But this is returning the error:

Expression.Error: There are too many elements in the enumeration to conclude the operation.
Details:
[List]

[mlsx4 · Accepted solution]

Hi @webportal 

It's working for me:

= Table.Pivot(#"Encabezados promovidos", List.Distinct(#"Encabezados promovidos"[question_text]), "question_text", "answer")

I have put this: 

The error will drop if your resulting table contains duplicated column names. Some topics treat it: https://community.fabric.microsoft.com/t5/Power-Query/There-were-too-many-elements-in-the-enumeratio...

https://www.youtube.com/watch?v=aTXQ77Vf5Gc