Forum Discussion
Receiving Error After Unpivoting Columns in Power Query
I'm trying to alphabetize a column of email addresses, separated by a semi colon. I found if I added an index column, split by delimiter, unpivoted the columns, sorted the rows, grouped the rows, and...
I still got an error with using your code but when I clicked "Remove Errors" on the Index, Attribute, and Value columns, the error got cleared. Is there a way to see where the error was? I'm now unsure how accurate my information is if I can't see what was removed.
renee_crozier , I'd start from Promote Headers step. At left bottom of Power Query Editor window set "Column profiling based on entire data set". On ribbon -> View enable Column Quality.
Check for which columns number of errors is not 0%. Select these columns, on ribbon Home->Keep Rows->Keep errors. Most probably you may identify the source of errors here.