Forum Discussion
Pivot Unpivot Multiple values
it's the #"Removed Columns" line. The pivot needs that column to identify unique rows.
So remove that step. You might want to filter out blank values from the Value column also.
Then do the pivot.
If you need to filter out rows after that then you can identify them at that stage.
There are definitely examples of this in this forum.
The basic algorithm is :
Select the first two columns->Unpivot other columns
Split the Attribute Column to make 2 columns. The left one (call it C1) will be a limited set of values which will be the new column headings.
Pivot the C1 column using Values column in Values and "Don't Aggregate" in the Advanced Section.
For sample data as provided that will work. The real data may not have numbers after the words so may be a little more complex.
--
Good luck
Thank you for replying. I tried all those steps, when I try to pivot as the last step I'm getting Expression Error: There were too many elements in th enumeration to complete the operation. Details: [List].
Which I understand as there are multiple values for the same field which should be treated as a duplicate (for all other values except the currrent one) record as shown in the example above and create a new row, but that's not happening. Any suggestions on how to work around this error?