Combine and sum values from multiple rows into one row

[Anonymous]

Please help me combine multiple rows into one and add the hours as shown here.

I am a new to Power BI and will greatly appreciate your help.

[tgo]

hi @Anonymous,

Make sur that when you add the Hours in your column you click on it in Values to select Sum.

[Anonymous]

Thank you! How do you combine the rows into one row? Sorry I am really really new to this.

The top table is what I have. I need what I have to look like the bottom table with the values summed.

[tgo · Accepted solution]

This is your data when you import them in Power BI.

Then you go on report, in the visualisation you chose table.

Then you drag and drop all your column that you need in "Values". And by left clicking in the Hours 1 in values you have all the options in my previous post and you chose "Sum". You do it for all the Hours column and you'll obtain the result I showed.

[Anonymous]

Thank you Frequent Visitor! I was making it too difficult.