Transform table: multiple blank values, convert into one row

[Anonymous]

Hi @all,

I have the following table: 

attribute	value1	value2	value3	value4	value5
A	11	0	0	0	0
A	0	22	0	0	0
A	0	0	33	0	0
A	0	0	0	44	0
A	0	0	0	0	55
B	13	0	0	0	0
B	0	23	0	0	0
B	0	0	33	0	0
B	0	0	0	43	0
B	0	0	0	0	53

and would like to transform the table into following structure:

attribute	value1	value2	value3	value4	value5
A	11	22	33	44	55
B	13	23	33	43	53

What's the best way to realize this in PowerQuery?

Thanks in advance!

[amitchandak · Accepted solution]

Use Group by

https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks#group-rows