Forum Discussion
How do I combine duplicate rows in Power Query?
Hello. I have 1369 entries for 'Cloud' and another 1578 entries for 'Cloud' in my treemap, as circled below in red. They're the same thing and I want to combine them. How do I combine these two in Power Query so that when I go back to my treemap, I see that 'Cloud' has 2947 entries? I'm a noob to this so I'm not sure how to do this transformation. Thank you.
Not sure, but you can try these options - Clean or Trim from transform options by right clicking on the column
7 Replies
Hello !
You can check data proofing options, there might be some space, newline or blankspaces added to column Value, you can try using remove blank or from Split Column Option.
I don't understand. What data proofing options? There are no spaces or blankspaces in 'Cloud'. How do I know if there's a newline added? None of this makes sense.
f you go to View option from Power Query Editor, You will see Data Preview options like Monospaced, show whitespace - show whitespace is something which will show whitespace or newline characters if any
If you go to View option from Power Query Editor, You will see Data Preview options like Monospaced, show whitespace - show whitespace is something which will show whitespace or newline characters if any
