Forum Discussion
Error "There weren't enough elements in the enumeration to complete the operation." when Pivoting
I have a .txt file that I am running through Power Query and into Excel. The txt file is a simple format that has an item ID on one line and an error message on the next, eg: Item ABC Error Msg I...
adinezza See attached.
davidmaddock54 Thought of a quick-and-dirty way to fix it, though believe there should be a better way to do it.
I didn't dig your query, but it looks like result is not correct
rachel , we may simplify it to
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
GroupedID = Table.Group(Source, {"ID"}, {{"Columns", each [Number]}}),
Result = Table.FromColumns( GroupedID[Columns], GroupedID[ID] )
in
Resultdavidmaddock54 , if order of numbers in the source doesn't matter, perhaps it's better to sort them in columns as in next query in attached attached
SergeiBaklan Oops! Must have been confused.
Thank you! the code is so straightforward and self explanatory!
By comparison, the code generated by pressing "Group By" button now looks like a mess!
