Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
FelipMark
Helper II
Helper II

Transform lines in columns

I havae the following table

IDDATEQUESTIONANSWER
12301/01/2023namejorge
12301/01/2023age17
12301/01/2023gendermale
45601/02/2023namelara
45601/02/2023age24
45601/02/2023genderfemale


I want to transform the rows into columns, like this:

IDDATENAMEAGEGENDER
12301/01/2023jorge17male
45601/02/2023lara24female


is an example, the table I have has 19 questions and when I use the dynamic columns option and select the option to not summarize the data, the following error appears:

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

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)

Thank you!!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.