Keep the customer single with the data on a single line

[Anonymous]

Can anyone give me any idea how to merge the data from the same customer on the same line? The Api brings the data in a very bad way, I did my best but still couldn't delete the null and keep the customer data on the table line.

[Anonymous]

Hi, @v-chenwuz-msft 

Thanks for your solution, but I have several columns that make this solution impossible.

For example:

 

[v-chenwuz-msft]

Hi @Anonymous ,

You can use Unpivot to do that.

Please refer the steps displaied by the gif.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.