I am tasked to complete a quality check on excel. Background - We receive several excel files from different vendors daily. Before putting on the BI tool i need to make sure the naming convention is matching what is in Power BI and check 4-5 columns to see if they are accurately populated. Sometime the rows in few columns are empty and they are populated by hyphens with space leading and trailing it ( - ).
Currently i am updating this manually. Is there a faster way to do this? Check the files to see the naming is correct and the columns have consistent data type.