How do I combine duplicate rows in Power Query?

[brown1001]

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.

[JadhavVarsha_13]

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 

[JadhavVarsha_13]

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. 

[brown1001]

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.

[JadhavVarsha_13]

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 

[brown1001]

Ok. I got rid of the whitespaces but it didn't change anything. I still have 2 separate 'Cloud' entries.

[JadhavVarsha_13 · Accepted solution]

Not sure, but you can try these options - Clean or Trim from transform options by right clicking on the column

[brown1001]

Thank you so much! That worked.