Is this merge possible in Power BI ?

[lcroitoru]

table 

col1	col2	col3	col4	col5	col6	col7	col8	col9
2018-02-22	A	B	C	D	625.2	E	K	448
2018-02-22	A	B	C	D	625.2	F	L	5.35
2018-02-22	A	B	C	D	625.2	G	M	35.71
2018-02-22	A	B	C	D	625.2	H	N	87.39
2018-02-22	A	B	C	D	625.2	I	O	25.11
2018-02-22	A	B	C	D	625.2	J	P	33.93
2018-02-22	A1	B1	C1	D1	14849.5	E1	K1	13294.21
2018-02-22	A1	B1	C1	D1	14849.5	F1	L1	427.03
2018-02-22	A1	B1	C1	D1	14849.5	G1	M1	631.85
2018-02-22	A1	B1	C1	D1	14849.5	H1	N1	326.07
2018-02-22	A1	B1	C1	D1	14849.5	I1	O1	146.36
2018-02-22	A1	B1	C1	D1	14849.5	J1	P1	6.86

result should be :

col1	col2	col3	col4	col5	col6	col7	col8	col9
2018-02-22	A	B	C	D	625.2	E	K	448
2018-02-22						F	L	5.35
2018-02-22						G	M	35.71
2018-02-22						H	N	87.39
2018-02-22						I	O	25.11
2018-02-22						J	P	33.93
2018-02-22	A1	B1	C1	D1	14849.5	E1	K1	13294.21
2018-02-22						F1	L1	427.03
2018-02-22						G1	M1	631.85
2018-02-22						H1	N1	326.07
2018-02-22						I1	O1	146.36
2018-02-22						J1	P1	6.86

the point is to merge col2 to col 6 where the values are the same , but leave the other columns as they are .

thx .

[v-ljerr-msft]

Hi @lcroitoru,

I don't think there is an easy way to merge the rows for those columns in that way currently.

Could you tell us why you need to merge them in that way, so that we may find an alternative solution for you? 

Regards

[lcroitoru]

Hi , 

I think this way is  more user friendly .

You can think at col 2  as a product with col 3 to 5 as descriptions and col 6 some quantity of that product .

Col's 7 to 9 are results from that product .

thx .