How to remove null v alues from multiple columns in one go and get a Tabular view

[ashicool_10061]

HI There,

I am stuck in Power Query where i have 6 columns with null values on alternate rows and column and i want to remove those Null values and geta clean Tabular view .

Please see below screenshot :

Issue in Power Query :

   

Eaxpected Result:

Can anyone help me how to get it done in one go .?

Thanks,

Ash

@SamWiseOwl @amitchandak @Ashish_Mathur 

[Jpss]

hello @ashicool_10061 

here is the solution i have created for this scenario. the Key  step is to fill down the first column, and then remove null values from second. that will clean up all your rows. 

Here is the pbix for your reference : ashicool_10061_jpss_sol.pbix

[Ritaf1983 · Accepted solution]

Hi @ashicool_10061 

If I understood correctly, the challenge here is that the null values for the other fields don't match the null values in the rows with names. The solution would be to:

1. Perform a fill-down operation on the names so that each row has a name.

2. Filter out the null values for the dates/other fields.

If something was missed since you only attached an image,

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

The pbix with my example is attached

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

[ashicool_10061]

Hi , Thank you for your response . 
It worked. Appreicate your help.

Thanks,

Ash