Remove rows that have a null value in a specific column?

[Anonymous]

I have a column "Process Step" with qualitative data, but there are many "null" values that prevent me from pivoting the column. I get errors I can't pivot cause of NA values or blank

I do NOT want to keep rows with nulls. I want to remove these rows entirely.

How can I edit the query and removet hese rows where null exists in a specific column? 

[ryan_mayu · Accepted solution]

@Anonymous 

I think you can add a step in the PQ which is filtering that column

[Anonymous]

---

@ryan_mayu wrote:

@ryan_mayu

I think you can add a step in the PQ which is filtering that column

---

You can add a step to filter the column, but doing so doesn't appear to let me pivot still. I get "DataFormat.Error: Invalid cell value '#N/A'." when I try to pivot. 

[ryan_mayu]

@Anonymous 

could you please provide the sample data and the expected output?

[Anonymous]

Filtering it did work actually. I was doing something wrong. Thanks!