Pivot a column with TEXT content IN POWER QUERY

Question

Hi, I need the values in my column Attribute1 to be converted into columns (three columns in this case) and filled with the values in the column 'values'. I need to do this in Power Query. I give an example of the result I need. I'm trying to do it using Pivot Table, choosing the Value column('Values') and the 'don't aggregate' option. but it shows me this error "Expression.Error: There were too many elements in the enumeration to complete the operation. Details: [List]" I appreciate the help. Original data:

Ouptut:

Answer 1

Hi @Fredy Herrera

In my opinion you may add one extra column, and use uniqueness of this column to pivot.

• So please group your table by "Attribute.1", the Operation is "All Rows".
• Add a custom column, and use this formula =Table.AddIndexColumn([All],"Index",1).
• Expand the query table, please don't tick "Attribute.1".
• Then remove the previous extra column, pivot the table as you did before. Choose the Value column and the "Don't aggregate" option.
• Remove the Index column, then you will get the one.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---