Merge rows with same ID, but then sum the values in another row.

[michdeblasi]

I have lots of rows of data some rows have duplicate values in a certain row. I want to merge those rows into one.  However there are other columns in that row that have values that I need to sum together to give a new value.  I actually have two columns in the rows. 

I read somewhere on this board to convert all the columns to text. So I have done that. 

Here is an example:

I want all the rows to stay the same but sum GB Usage column, and sum Count column.  So it looks like this:

I have searched the knowledgebase and cannot get the right steps.

Any help appreciated

[amitchandak]

@michdeblasi , I think a simple sum of these columns in the visual can do.

or you can do group by in power query https://docs.microsoft.com/en-us/power-query/group-by

[michdeblasi]

All thank you for this, I finally figured out how to group by properly.  

Thank you again.

[michdeblasi]

I am sorry but I am fairly new, I don't understand the sum by column, I only want the sum if there are duplicate numbers.  I don't want the entire column of GB usage to be totalled. 

I was doing the Group By but that didn't seem to work, it was just generating errors. 

It is a shame you cannot just select the rows you want to merge and they merge similar to selecting two columns.