Please tell me how to add a row with the same ID and user duplicated.

[Tome_05]

Thank you as always.

I have data like the attached image 01 in PowerBI. Is there a way to make it look like attached image 02?

Thank you in advance.

[AnkitaaMishra · Accepted solution]

Hi @Tome_05 , 
Yes you can achieve this in Power Query editor by following below steps :
1) Split the "fruit" column by right clicking and choose option:
 

2) Choose option space for getting the values: 

3) Select all the split column and use unpivot to get the desired result (you can remove the extra column if not needed)

Thanks,

Ankita

[Idrissshatila]

Hello @Tome_05 ,

yes, first you split column 3 by delimiter to have a seperate column for each value.

check how to do it https://learn.microsoft.com/en-us/power-query/split-columns-delimiter

the you unpivot these columns

check it out https://learn.microsoft.com/en-us/power-query/unpivot-column