This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As part of a use case development, I thought of making this macro which would remove columns having null values. User can input the percentage of null values a column should possess in order to remove them.
I have attached the macro. I hope it might be useful for some of your data pre-processing.
Very clever! This can also be useful with Excel spreadsheets that have formatting in cells to the right of the normal data but no values in them causing additional columns to be read into a workflow with null values.