Forum Discussion
Deleting/filtering every row with null values in every column
Hello community, I have merged 40 tables. Every table has between 100-500 rows null values across the entire entire row, where there might only be between 5-100 rows with data in them. I wish to d...
- Select all the columns you want Anonymous to test for null on.
- In the Add Column ribbon, select Merge Columns with no special delimiter.
- Filter that newly Merged column for null, or select the "remove empty" filter. Remove Empty will remove blanks and nulls.
- Delete the temporary merged column.
edhans
Community Champion
Community Champion- Select all the columns you want Anonymous to test for null on.
- In the Add Column ribbon, select Merge Columns with no special delimiter.
- Filter that newly Merged column for null, or select the "remove empty" filter. Remove Empty will remove blanks and nulls.
- Delete the temporary merged column.
Hello, I edited the text as I discovered that I do not have the exact same amount of columns. Could you take a look at it again?