datatronics505
Board Regular
- Joined
- Nov 26, 2022
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
As a result of wrangling a badly formatted text file into submission in the form of an ordinary table via Power Query, I got a query with a lot of cells whose value is null. They are scattered everywhere. The filter tool at the column header isn't helping much:
How can I remove all those null values and only the null values?
How can I remove all those null values and only the null values?