Group by on 244 columns - keep the value and remove the "null"

[dez_im_ope]

Hello all,

I creating a dashboard from a Form, which contains 2 sections. Each respondent has a unique case_number, the first day he will enter his case_number and answer Section A, then submit his form. the second day he will enter again his case_number, answer Section B and submit his form.

Therefore, in my database I have 2 rows for each case, but only 1 value per column per case (in the row for section A, all the columns of section B are empty, and vice-versa). As below :

And this what I need: 

to have only one row for each respondent.

Not that complicated with Max in Advanced Group By in PowerQuery... except I have 244 columns!!! And I need to keep them all...
Is there a way to group by my case_number and then to keep the value (instead of the "null") for all my columns?

Many many thanks for your support!

Ophelie

[davehus]

Hi @dez_im_ope ,

There's no easy way to do this. It's either create a view in your database with the data summarized or use the group by in Power Query (i'm not sure if there is a capacity limit). I'd be inclined to create a view upstream in the database if possible from a performance standpoint.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

[dez_im_ope]

Hello, thank for your help!
I am not sure to understand what you mean by "create a view upstream" ..?

I guess I will separate my dataset in 2 datasets and then merge them again

Thank you!